请教,这两句查询语句怎么合并成一句啊,谢谢!

Question

如题: 语句1: select m.mEmail,a.aAuditor from Members as m,taskApply as a where a.aAuditor=m.mName 语句2: select count(*) from taskApply where aAuditor is not null group by aAuditor

Answer 1

如果有group by

你要查询的字段要么在group by 后面  ，要么在  聚合函数里面   就像你第二个语句中的count(*)

Answer 2

select m.mEmail,a.aAuditor,count(*) as val from Members as m,taskApply as a where a.aAuditor=m.mName

where aAuditor is not null  group by m.mEmail,a.aAuditor

大致语句应该是这样的，没有调试过，按照这个方向去试一下吧！