USE T202425

DELETE FROM CUSTOMER_MASTER WHERE CustCode NOT IN (
SELECT VouCustCode FROM PURCHASE_DETAIL UNION
SELECT VouCustCode FROM OPENING_PURCHASE_DETAIL UNION
SELECT RecCustCode FROM RECEIVED_DETAIL UNION
SELECT RtnCustCode FROM RETURN_GOODS_DETAIL UNION
SELECT BrokCustCode FROM BROKERAGE_DETAIL UNION
SELECT BrokCustCode FROM BROKERAGE_DETAIL UNION
SELECT OrdCustCode FROM ORDER_DETAIL UNION
SELECT OrdCustCode FROM OPENING_ORDER_DETAIL UNION
SELECT ChqCustCode FROM CHEQUE_RETURN_DETAIL UNION
SELECT CustCode FROM POST_RECEIVED UNION
SELECT CustCode FROM BILLS_INTEREST_CALCULATION
)

0
DELETE FROM SUPPLIER_MASTER WHERE SuppCode NOT IN (
SELECT VouSuppCode FROM PURCHASE_DETAIL UNION
SELECT VouSuppCode FROM OPENING_PURCHASE_DETAIL UNION
SELECT RecSuppCode FROM RECEIVED_DETAIL UNION
SELECT RtnSuppCode FROM RETURN_GOODS_DETAIL UNION
SELECT BrokSuppCode FROM BROKERAGE_DETAIL UNION
SELECT BrokSuppCode FROM BROKERAGE_DETAIL UNION
SELECT OrdSuppCode FROM ORDER_DETAIL UNION
SELECT OrdSuppCode FROM OPENING_ORDER_DETAIL UNION
SELECT ChqSuppCode FROM CHEQUE_RETURN_DETAIL UNION
SELECT SuppCode FROM POST_RECEIVED UNION
SELECT SuppCode FROM BILLS_INTEREST_CALCULATION
)