56,940
社区成员




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
.