BEGIN UPDATE smstorelocations l SET l.flags=3076 WHERE l.ID NOT IN (SELECT LS.ID FROM SUPERMAG.SVLOCALSHOPS LS WHERE LS.LOCTYPE = 4) AND l.loctype>=0; delete from smgoods where storeloc not in (SELECT LS.ID FROM SUPERMAG.SVLOCALSHOPS LS WHERE LS.LOCTYPE = 4); commit; END; /