I am trying to create a simple union query and I keep getting a syntax error in the from clause. This is my SQL statement:
SELECT CoName1, StatusID
FROM qryMeetingMembersNOTComing-crb
UNION SELECT CoName1, StatusID
FROM qryMeetingALLRegistrantMembers-NOreminders;
Can anyone tell me what I am doing wrong?
SELECT CoName1, StatusID
FROM qryMeetingMembersNOTComing-crb
UNION SELECT CoName1, StatusID
FROM qryMeetingALLRegistrantMembers-NOreminders;
Can anyone tell me what I am doing wrong?