表A:
aid aname bid cid
1 aa 2 1
2 bb 1 2表B:
Bid bname
1 asd
2 ads表C:
Cid cname
1 1111
2 2222
怎么查询获取 :
aname bname cname
aa ads 1111
bb asd 2222
aid aname bid cid
1 aa 2 1
2 bb 1 2表B:
Bid bname
1 asd
2 ads表C:
Cid cname
1 1111
2 2222
怎么查询获取 :
aname bname cname
aa ads 1111
bb asd 2222
from tbA a inner join tbB on a.bid=b.Bid
inner join tbC c on a.cid=c.Cid
from tbA a,tbB b,tbC where a.bid=b.Bid and a.cid=c.Cid
select t.aname,a.bname,b.cname
from tbA t
inner join tbB a on t.bid=a.Bid
inner join tbC b on t.cid=b.Cid
--方法二select a.aname,b.bname,c.cname
from tbA a,tbB b,tbC
where a.bid=b.Bid and a.cid=c.Cid