> 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 ?