原来的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