select from one table where not on the other
snippet in sql

select from one table where not on the other

user6454

SELECT id FROM a.table
WHERE id NOT IN (SELECT b.id FROM b.id)