Query that returns no-matching records.

[fabio.degani]

I have a question that might be basic, but I don't know how to do it.

Suppose I have two tables with fields as follows:

Assigned Courses (Courses that employees should do)

• Employee number
• Assigned Course Name

Fulfilled Course (Courses that employees have done)

• Employee number
• Fulfilled Course

Now I need to do a query that tells me which employees haven't done. Is there anyway to do that that is not an exclude query?

 

[plog]

Your query would be based on a LEFT JOIN (http://www.w3schools.com/sql/sql_join_left.asp) from Assigned Courses to Fulfilled Courses and you would put criteria on the Fulfilled Courses's Employee number field to show all that are null.

 

[rzw0wr]

Try Querying for Null in the field Fulfilled Course or whatever field that shows the task complete.

Dale

 

[fabio.degani]

Your query would be based on a LEFT JOIN (link) from Assigned Courses to Fulfilled Courses and you would put criteria on the Fulfilled Courses's Employee number field to show all that are null.

Good! It works!

Let's suppose another possibility: on the fulfilled courses table I have a true/false field to be marked when the course is actually done.

This is to control whether the employee is late on doing a course.

This query is to assign new courses to employess who are on schedule, and to warn those who are late.

In this case, the "assigned courses" would be a table that contains all the courses that one employee should do on his "life".

Any ideas?

 

[fabio.degani]

Try Querying for Null in the field Fulfilled Course or whatever field that shows the task complete.

Dale

Thanks, Dale, but on the fulfilled course I have only courses that were previously assigned to that employee. Now I have to mark them as "done" (for those who actually did it). Next step is to assign new courses for people who did their tasks, and to warn those who didn't.

Hope I could make myself understood. English tips are also highly appreciated.