求关联两张表的一查询sql

[fooms]

表T1 id name
1001 aa
1002 bb
1003 cc
表T2 id msg
1001 abcd
1001 bdfd
1003 fdsf
查询结果是id为1001 的数量为2 ，id为1002 的数量为0，id为1003 的数量为1

[WangZWang]

select a.id,isNULL(count(b.id),0) as cnt
from t1 as a Left join t2 as b on a.id=b.id
group by a.id

[lxysjl]

接分

[cnlover8]

1楼的正确。也可写如下
select T1.id ,isNULL(count(T1.id),0) as counter from T1 left join T2 on T1.id=T2.id group by T1.id

[long_205]

select a.id,isNULL(count(b.id),0) as cnt
from 表t1 as a Left join 表t2 as b on a.id=b.id
group by a.id

[mahf]

1楼正确!
select a.id,isNULL(count(b.id),0) as cnt
from t1 as a Left join t2 as b on a.id=b.id
group by a.id

[fooms]

谢谢，我验证下。马上散分

[cym7808]

不需要GROUP BY 吧

select * from t1 a,t2 b
where a.c_id=b.c_id