Intern — Middle
Output the ids from table B that are missing in table A
livecode
Task condition
There are two tables, each containing a column id. You need to write a query that returns all id values from the second table, but only those that are not in the first.
A B
+----+ +----+
| id | | id |
+----+ +----+
| 1 | | 2 |
| 2 | | 3 |
| 3 | | 4 |
| 7 | | 5 |
| 12 | | 6 |
| 17 | | 7 |
| 19 | | 17 |
+----+ | 8 |
+----+