UC知道帮忙写个sql语句
来源：百度知道 编辑：UC知道 时间：2024/05/12 12:08:57
有三个表：
user1表:
userid,username,mail
ware表:
wareid,warename,price,ptime
price表:
priceid,userid,wareid,price,ptime,
现在想要 查到 ，
user1.username, were.warename,pr
ice.price,price.ptime
我这样写不行
select user1.username ,ware.warename,price.price,price.ptime
from user1,price,ware
where price.userid=529 and price.wareid=1004
谁帮我写的完整些 ...........谢谢
user1表:
userid,username,mail
ware表:
wareid,warename,price,ptime
price表:
priceid,userid,wareid,price,ptime,
现在想要 查到 ，
user1.username, were.warename,pr
ice.price,price.ptime
我这样写不行
select user1.username ,ware.warename,price.price,price.ptime
from user1,price,ware
where price.userid=529 and price.wareid=1004
谁帮我写的完整些 ...........谢谢
select user1.username,ware.warename,price.price,price.ptime
from user1,ware,price
where price.userid=user1.userid and price.wareid=ware.wareid and user1.userid='' and ware.wareid=''
恩！你写的sql语句还可以！
没有错误你直接运行吧！
有什么问题发站内信过来！
最好用join写,from tab1,tab2,tab3相当于三个表做迪卡尔乘积,这样消耗相当大,而且你的搜索条件好象不够,例如
user1.userid = price.userid,
ware.wareid = price.wareid
select user1.username ,ware.warename,price.price,price.ptime
from user1,price,ware
where user1.userid = price.userid and ware.wareid = price.wareid and price.userid = 529 and price.wareid = 1004