INSERT INTO tabelle3 ('spalte2') SELECT t1.spalte2 FROM tabelle1 t1 LEFT JOIN tabelle2 t2 ON t2.spalte4 = t1.spalte2 WHERE t2.spalte4 IS NULL;