C
cherman
I have 2 tables. One is a user table (tblUsers) and the 2nd is a table that
holds courses that users have taken (tblCourses). "ID" is the user id field
in tblUsers and "UserID" is the user id field in tblCourses.
I want to select all users from tblUsers who have not taken any courses (not
in tblCourses). I thought I would use a NOT IN subquery, but I cannot get it
right.
Also, there are 2 fields in tblUsers that are criteria: UserStatus = "EU"
and DisplayOnly <> "Y".
Can anyone help me figure this out?
Thanks in advance,
Clint
holds courses that users have taken (tblCourses). "ID" is the user id field
in tblUsers and "UserID" is the user id field in tblCourses.
I want to select all users from tblUsers who have not taken any courses (not
in tblCourses). I thought I would use a NOT IN subquery, but I cannot get it
right.
Also, there are 2 fields in tblUsers that are criteria: UserStatus = "EU"
and DisplayOnly <> "Y".
Can anyone help me figure this out?
Thanks in advance,
Clint