delete from alias where alias in (select itemlookupcode from item)