A bit of a noob question, but would appreciate the help.
I want to use the result of one select statement in a different one in a specific way.
The first select statemnent:
SELECT DISTINCT id FROM customers WHERE country = 'Neverland';
The result will be a one-column table with distinct IDs. Now I want to select all these IDs from a different table.
SELECT * FROM shipments WHERE [the id is contained within the first select statement]