62,046
社区成员
发帖
与我相关
我的任务
分享
SELECT a.id AS aid,b.bname,a.aname
FROM a LEFT JOIN b
ON a.bid=b.bid
SELECT a.id AS aid,b.bname,a.aname
FROM a,b
WHERE a.bid=b.bid
SELECT a.id AS aid,b.bname,a.aname
FROM a LEFT JOIN b
ON a.bid=b.bid
select a.id as aid, b.bname, a.aname
from a
left join b on a.bid=b.bid