I have three tables and I'm trying to find data that doesn't match.
Employee table with employee id, employee name, and hire date.
Employee ID
9
10
11
Technology Table with technology id and technology description
Technology ID
11
12
13
14
Employee_Technology table with the employee id and technology id
9 11
9 13
10 11
11 14
I need to find out what technologies individuals are missing.
I want the results to be
9 12
9 14
10 12
10 13
10 14
11 11
11 12
11 13
I've tried joining on the technology ids to show all from technology and only those in the employee_technology table that match and then putting Is Null as the criteria in the employee_technology table and I get no results. I've tried all the combinations of the above - changing joins, changing where the Is Null is - nothing gives me any results.
Any ideas what I'm missing?
Debi