下面是我使用WITH进行更多澄清的内容:(SELECT GRANTS.[Grant Program Number] AS GPN, Count(GRANTS.[Grant Awarded]) AS AwardCountWHERE GRANTS.[Grant Program Number] AS GPN, Count(GRANTS.[Grant Submitted]) AS SubCount WHERE
我有两张桌子,它们之间的关系是多到多的.一个表是Grants,另一个表是Key_People。
选择Grants.*,Key_People.firstName,Key_People.lastName FROM (赠款左加入Key_People_To_Grants ON Grants.grantID = Key_People_To_Grants.grantIDSELECT DIST