如何对一个表进行分组查询后再和其他表进行连接查询如题。。[解决办法]select a.*,b.*from table1 a inner join (select grpid,count(*) from table2 group by grpid) b on a.id=b.grpid