SQL Query - pretty simple

Databases
1

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.

2

Use an inner join on table 1 and 2, and a left join on table 1 and 3.

3

select uniqueID from tab1 inner join tab2 on tab1.uniqueID =tab2.employeeID
where tab.uniqueID not in (select employeeID from tab3)