SQL: select all unique values in table A which are not in table B

I have table A

Id  | Name      | Department
-----------------------------
0   | Alice     | 1
0   | Alice     | 2
1   | Bob       | 1

and table B

Id  | Name
-------------
0   | Alice

I want to select all unique Ids in table A which do not exist in table B. how can I do this?

sql mysql

Edit Report

0 Answers