delete from supplierlist where itemid not in (select [id] from item)
delete from alias where itemid not in (select [id] from item)