56,677
社区成员
发帖
与我相关
我的任务
分享
select aid,address,bname-(select bname from tb b where a.bid=b.bid),
cname-(select cname from tc c where a.bid=c.bid)
from ta a
select aid,address,bname-(select bname from tb b where a.bid=b.bid),
cname-(select cname from tc c where a.bid=c.bid)
from ta a
select a.aid,a.address,b.bname,c.cname
from (a left join b on a.bid=b.bid)
left join c on a.cid=c.cid
.