很久没写SQL,同志们来帮个忙写个SQL语句....

[wxm3630478]

很久没弄SQL啦....忘记的差不多

表名:Table_A
字段:ObjectID,ObjectName,CreateDate...
obj_001,张三,2010-06-10
obj_002,李四,2010-06-10
obj_003,王五,2010-06-10


表名:Table_B 评论表
字段:ID,ObjectID,CommentTxt,CommentDate
1,obj_001,人很好,2010-06-11
2,obj_001,人品不错哟,2010-06-11
3,obj_001,人很懂礼貌,2010-06-11
4,obj_002,人很烂呢,2010-06-12
5,obj_002,SB一个,2010-06-12
6,obj_003,好好人,2010-06-14


现在要查出来,查出某个人有多少条评论
如:
ObjectID,ObjectName,CreateDate,Num

obj_001,张三,2010-06-10,3 --张三3条
obj_002,李四,2010-06-10,2 --2条
obj_003,王五,2010-06-10,1 --1条


先谢啦,搞定马上结贴.......

[颤菊大师]

SELECT a.*,COUNT(b.*) as Num FROM Table_A a left join Table_B b on a.objectID = b.objectID GROUP BY ObjectID,ObjectName,CreateDate

没经过测试，你试试。

[caixia615]

select ObjectID,ObjectName,CreateDate ,count(CommentTxt)num from tablea join tableb
on tablea.ObjectID=tableb.ObjectID
group by ObjectID,ObjectName,CreateDate

[wxm3630478]

谢谢....现在测试

[wxm3630478]

恩 搞定...谢谢啦 结贴