请教一个Access/SQL的问题,谢谢

PerdingGu

我要在以下查询中去掉字段Aug_EA: Number of Easy Assist sessions， Aug_Recording: Number of Shared Recordings，Sep_EA: Number of Easy Assist sessions，和Sep_Recording: Number of Shared Recordings 都=0的记录，在下面的sql语句中怎么写？ 或者在access的图形界面中怎么实现，谢谢

SELECT MemberList.Name, MemberList.Email, MemberList.[Business Platform], MemberList.Division, MemberList.[Job Function], MemberList.[Office Country], usageEasyAssistCSV_Aug.[Number of Easy Assist sessions] AS Aug_EA, usageRecordingCSV_Aug.[Number of Shared Recordings] AS Aug_Recording, usageEasyAssistCSV_Sep.[Number of Easy Assist sessions] AS Sep_EA, usageRecordingCSV_Sep.[Number of Shared Recordings] AS Sep_Recording
FROM (((MemberList LEFT JOIN usageEasyAssistCSV_Sep ON MemberList.Name = usageEasyAssistCSV_Sep.[Organizer Name]) LEFT JOIN usageRecordingCSV_Aug ON MemberList.Name = usageRecordingCSV_Aug.[Organizer Name]) LEFT JOIN usageRecordingCSV_Sep ON MemberList.Name = usageRecordingCSV_Sep.[Organizer Name]) LEFT JOIN usageEasyAssistCSV_Aug ON MemberList.Name = usageEasyAssistCSV_Aug.[Organizer Name]
GROUP BY MemberList.Name, MemberList.Email, MemberList.[Business Platform], MemberList.Division, MemberList.[Job Function], MemberList.[Office Country], usageEasyAssistCSV_Aug.[Number of Easy Assist sessions], usageRecordingCSV_Aug.[Number of Shared Recordings], usageEasyAssistCSV_Sep.[Number of Easy Assist sessions], usageRecordingCSV_Sep.[Number of Shared Recordings]
ORDER BY usageEasyAssistCSV_Aug.[Number of Easy Assist sessions] DESC , usageRecordingCSV_Aug.[Number of Shared Recordings] DESC , usageEasyAssistCSV_Sep.[Number of Easy Assist sessions] DESC , usageRecordingCSV_Sep.[Number of Shared Recordings] DESC;