select A.AID,A.Name,B.Name from A,B where A.BID = B.BID或者 select A.AID,A.Name,( select B.Name from B where B.BID = A.BID )from A
select a.aid,a.name,b.name from a left join b on a.bid = b.bid
