一个sql 组合查询的问题

[uhoo]

A 表结构 Aid Atitle
B 表结构 Bid Aid
C 表结构 Cid Aid

三个表中，Aid相互关联，每一个A表的数据都对应多个B和多个C

要求查询出如下结果

Aid Atitle B表对应Aid的记录条数 C表对应Aid的记录条数

[slayerbb]

select a.aid,a.atitle,
(select count(id) from tableb b where b.aid=a.id) as bnumber,
(select count(id) from tablec c where c.aid=a.id) as cnumber
from tablea a

[竹林听雨2005]

楼上那结果好象不对

[uhoo]

事实证明是正确的，谢谢了！接分！

[uhoo]

结束

[despider]

select a.aid,a.atitle,
(select count(bid) from b where b.aid=a.aid) as bnumber,
(select count(cid) from c where c.aid=a.aid) as cnumber
from a

或者

select a.aid, a.atitle, bb.bcnt, cc.ccnt from a,
(select aid, count(bid) as bcnt from b group by aid) bb,
(select aid, count(cid) as ccnt from c group by aid) cc where a.aid=bb.aid and a.aid=cc.aid