Intern — Middle
Extracting missing identifiers from the second table
livecode
Task condition
There are two tables — "A" and "B". It is required to write an SQL query that returns all the values of the 'id' column from table "B" that are missing in table "A".
A | B
--- | ---
id | id
1 | 2
2 | 3
5 | 4
7 | 5
9 | 7