G
Guest
Hello,
I have a database that keeps track of employee training. I also have a table
of classes that list the training classes each employee is supposed to take.
I created an unmatched query, but it didn't work right.
I want all classes that do not appear in the employees training to show up
after the query.
I did get some results, but they were incorrect. Here's the SQL:
SELECT qrytrainingall.Last, qrytrainingall.First, qrytrainingall.[Class
Name], qrytrainingall.[Employee Number]
FROM qrytrainingall LEFT JOIN tblHOURLYrequiredclasses ON
qrytrainingall.[Class Name] = tblHOURLYrequiredclasses.[Class Name]
WHERE (((tblHOURLYrequiredclasses.[Class Name]) Is Null));
Not sure what I'm doing wrong but sure I'm close,
John.
I have a database that keeps track of employee training. I also have a table
of classes that list the training classes each employee is supposed to take.
I created an unmatched query, but it didn't work right.
I want all classes that do not appear in the employees training to show up
after the query.
I did get some results, but they were incorrect. Here's the SQL:
SELECT qrytrainingall.Last, qrytrainingall.First, qrytrainingall.[Class
Name], qrytrainingall.[Employee Number]
FROM qrytrainingall LEFT JOIN tblHOURLYrequiredclasses ON
qrytrainingall.[Class Name] = tblHOURLYrequiredclasses.[Class Name]
WHERE (((tblHOURLYrequiredclasses.[Class Name]) Is Null));
Not sure what I'm doing wrong but sure I'm close,
John.