delete from relmenudisplays where (valueid) in (select displayid from displays where displays.allorders=1); delete from relmodifierdisplay where (valueid) in (select displayid from displays where displays.allorders=1);