SELECT a.SUBJECTID ,COUNT(*),b.SUBJECT FROM table1 a,table2 b WHERE a.SUBJECTID=b.SUBJECTID GROUP BY a.SUBJECTID,b.subject
查看联机帮助,看看group by 的使用方法!
--未包含在聚合函数中的字段,都要出现在group by中SELECT a.SUBJECTID ,COUNT(*),b.SUBJECT FROM table1 a,table2 b WHERE a.SUBJECTID=b.SUBJECTID GROUP BY a.SUBJECTID ,b.SUBJECT
FROM table1 a,table2 b
WHERE a.SUBJECTID=b.SUBJECTID
GROUP BY a.SUBJECTID ,b.SUBJECT