56,687
社区成员
发帖
与我相关
我的任务
分享求两个表不同字段联合查询语句
table a{id,name};
table b{id,money};
求:
table{a.id,a.name,b.money}
a.id=b.id order by b.money desc limit 10;
table b{id,money};
求:
table{a.id,a.name,b.money}
a.id=b.id order by b.money desc limit 10;
...全文
请发表友善的回复…
发表回复
ACMAIN_CHM 2013-07-18
- 打赏
- 举报
select a.id,a.name,b.money
from a,b
where a.id=b.id order by b.money desc limit 10;
WWWWA 2013-07-18
- 打赏
- 举报
select a.id,a.name,b.money
from a INNER JOIN b ON a.id=b.id order by b.money desc limit 10;
