devi usare la NOT IN

SELECT colonne FROM tabella1 WHERE id NOT IN (SELECT id FROM tabella2)

facce sape'