Table 1
uniqueID / employeeName
1 / Dave
2 / Steve
3 / Robert
Table 2
job / employeeID
“telephone Mr Smith” / 2
“complete report abc” / 1
Table 3
notes / employeeID
“various text entered here” / 2
“hello, more notes” / 2
For my sql query I need to check which employees (from table 1 and if any) DO appear in table 2, but then not in table 3. In this case this would be YES, employee 1.