Counting and joining Part II

[emozley]

I have tried to extend the query so that it also performs a similar operation with another table this one called ExternalAttendees but the values are returned for exttotal and extnotarrived are always the same as inttotal for some reason. Thanks very much.

SELECT M.StartTime, M.EndTime, M.MeetingID, M.Provisional, M.Food, count(A.MeetingID) AS inttotal, Sum(IIf(A.Arrived,0,1)) AS intnotarrived, count(E.MeetingID) AS exttotal, Sum(IIf(E.Arrived,0,1)) AS extnotarrived
FROM (Meetings AS M LEFT JOIN Attendees AS A ON A.MeetingID=M.MeetingID) LEFT JOIN ExternalAttendees As E ON E.MeetingID=M.MeetingID
WHERE M.Date=#2/1/2006# And M.RoomID=5
GROUP BY M.StartTime, M.EndTime, M.MeetingID, M.Provisional, M.Food
ORDER BY M.StartTime;