求sql语句，left join

[骄傲青蛙]

A(tid,fid,subject) //A table

B(aid,tid,name) //B table

select A.*, count(*) from A left join B On A.tid = B.tid;

A表每条记录都唯一的，B表的tid字段有很多相同，

现在要查询A表之后，在最后一列加入B表以A.tid这个条件查询的记录的总条数，

这样写对不，好像没效果。

[ACMAIN_CHM]

select a.tid,a.fid,a.subject,count(b.tid)
from a left join b on a.tid=b.tid
group by a.tid,a.fid,a.subject

[骄傲青蛙]

I finish myself when i posted the article, but thanks for ACmAIN_CHM who are good man.