Sobes.tech
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 |
         +----+