delete from SCREEN_ITEM_MASTER WHERE ITEMNAME NOT IN 
(
SELECT ItemRangeDesp FROM T19I001.DBO.FINISHED_PURCHASE_ITEM_DETAIL UNION
SELECT ItemRangeDesp FROM T20I001.DBO.FINISHED_PURCHASE_ITEM_DETAIL UNION
SELECT ItemRangeDesp FROM T21I001.DBO.FINISHED_PURCHASE_ITEM_DETAIL UNION
SELECT ItemRangeDesp FROM T22S001.DBO.FINISHED_PURCHASE_ITEM_DETAIL UNION
SELECT ItemRangeDesp FROM T23S001.DBO.FINISHED_PURCHASE_ITEM_DETAIL UNION
SELECT ItemRangeDesp FROM T19I001.DBO.BILL_ITEM_DETAIL UNION
SELECT ItemRangeDesp FROM T20I001.DBO.BILL_ITEM_DETAIL UNION
SELECT ItemRangeDesp FROM T21I001.DBO.BILL_ITEM_DETAIL UNION
SELECT ItemRangeDesp FROM T22S001.DBO.BILL_ITEM_DETAIL UNION
SELECT ItemRangeDesp FROM T23S001.DBO.BILL_ITEM_DETAIL UNION
SELECT ItemRangeDesp FROM T19I001.DBO.FINISHED_PURCHASE_RETURN_GOODS_ADDLESS_DETAIL UNION
SELECT ItemRangeDesp FROM T20I001.DBO.FINISHED_PURCHASE_RETURN_GOODS_ADDLESS_DETAIL UNION
SELECT ItemRangeDesp FROM T21I001.DBO.FINISHED_PURCHASE_RETURN_GOODS_ADDLESS_DETAIL UNION
SELECT ItemRangeDesp FROM T22S001.DBO.FINISHED_PURCHASE_RETURN_GOODS_ADDLESS_DETAIL UNION
SELECT ItemRangeDesp FROM T23S001.DBO.FINISHED_PURCHASE_RETURN_GOODS_ADDLESS_DETAIL UNION
SELECT DesignScreen FROM T19I001.DBO.RECEIVED_RETURN_GOODS_ITEM_DETAIL UNION
SELECT DesignScreen FROM T20I001.DBO.RECEIVED_RETURN_GOODS_ITEM_DETAIL UNION
SELECT DesignScreen FROM T21I001.DBO.RECEIVED_RETURN_GOODS_ITEM_DETAIL UNION
SELECT DesignScreen FROM T22S001.DBO.RECEIVED_RETURN_GOODS_ITEM_DETAIL UNION
SELECT DesignScreen FROM T23S001.DBO.RECEIVED_RETURN_GOODS_ITEM_DETAIL
)