UPDATE firma1.rid SET toode=NULL WHERE toode IS NOT NULL AND toode NOT IN (SELECT TOODE FROM firma1.TOODE);
Why not use a LEFT JOIN for this ? ---------------------------(end of broadcast)--------------------------- TIP 5: don't forget to increase your free space map settings