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.