Hi Guys and Gals
I have 2 SQL statements that i've created in MSAccess but ideally i want just one SQL.
SELECT Roster.member, Attendance.date
FROM Roster, Attendance
GROUP BY Roster.member, Attendance.date;
This SQL creates a list of all members and all possible dates.
SELECT JAGM1.member, JAGM1.Date
FROM (Attendance RIGHT JOIN JAGM1 ON (Attendance.member = JAGM1.member) AND (Attendance.date = JAGM1.date)) LEFT JOIN Roster ON JAGM1.member = Roster.member
WHERE (((JAGM1.Date)>=([Roster].[join_date])) AND ((Attendance.member) Is Null));
This query uses the result of JAGM1 (which is generated from statement 1) to find some unmatched records that fall on or after the join date.
Is it possible to combine the two SQL statements into one?