delete from supplierlist where supplierid not in (select [id] from supplier)