试图执行的查询中不包含作为合计函数一部分的特定表达式 'id'

 

 

原来的sql语句:

 

select a.*,count(b.aid) as num from A as a right join B as b on a.id=b.aid order by a.id desc

 

提示错误:

 

试图执行的查询中不包含作为合计函数一部分的特定表达式 'id' 。

 

修正后的sql语句:

 

select a.id,a.a,a.b,count(b.aid) as num from A as a right join B as b on a.id=b.aid group by a.id,a.a,a.b order by a.id desc