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