Query to get result from 3 tables

[ikram]

I have three tables, Employee Details, Course completed, Training required as per various designation. Need to design a query to get the employees list course outstanding as per their designation. Course completed is linked to employee table by employee id. Training

[June7]

What is 'designation'?

Need a dataset that shows every course each employee required to take. Then join table of courses completed to that dataset and where completed is null, the course is outstanding.

[Dal Jeanis]

1) I see the training requirements for a designation, but I don't see that table linked to a course list.

2) I don't understand the purpose of CmpDet.

3) The basic method is to build (A) a query that shows all the required courses for a particular designation for a particular employee. Then build (B) a query that shows all courses completed by a particular employee. The report is then all courses on list A for an employee that are NOT IN list B.