USE DATABASE



delete FROM account_master where acccode COLLATE DATABASE_DEFAULT not in (SELECT CreditAcc FROM SCAN_BALANCE_SHEET UNION SELECT DebitAcc FROM SCAN_BALANCE_SHEET UNION SELECT CreditAcc FROM SCAN_BALANCE_SHEET UNION SELECT DebitAcc FROM SCAN_BALANCE_SHEET UNION SELECT TDSAcc FROM RECEIVED_FROM_JOB UNION SELECT ItemAccCode FROM OTHER_GOODS_ISSUE_ITEM_DETAIL UNION SELECT BkAccCode FROM RECEIVED_RETURN_GOODS_DETAIL UNION SELECT SaleRtnType FROM RECEIVED_RETURN_GOODS_DETAIL UNION SELECT AccTDSCode FROM TDS_TYPE_MASTER UNION SELECT TDSAcc FROM GENERAL_PURCHASE UNION SELECT CustCode FROM OUTWARD_DETAIL UNION SELECT WeaverCode FROM FINISHED_PURCHASE UNION SELECT BkAccCode FROM MULTI_JOURNAL_DETAIL UNION SELECT WeaverCode FROM OTHER_PURCHASE UNION SELECT PurType FROM OTHER_PURCHASE UNION SELECT PurType FROM OPENING_OTHER_PURCHASE UNION SELECT SuppCode FROM GENERAL_PURCHASE UNION SELECT PLAcc FROM GENERAL_PURCHASE UNION SELECT WeaverCode FROM INWARD UNION 
                SELECT WeaverCode FROM ISSUE_TO_PROCESS UNION SELECT WeaverCode FROM OPENING_INWARD UNION SELECT PartyCode FROM TDS_CERTIFICATE_DETAIL UNION SELECT BkAccCode FROM FINISHED_PURCHASE_RETURN_GOODS_DETAIL UNION SELECT DebitCode FROM JOURNAL_VOUCHER UNION SELECT CreditCode FROM JOURNAL_VOUCHER UNION SELECT CustCode FROM OPENING_OUTWARD_DETAIL UNION SELECT WeaverCode FROM OPENING_FINISHED_PURCHASE UNION SELECT WeaverCode FROM OPENING_OTHER_PURCHASE UNION SELECT BkAccCode FROM PAYMENT_BANK_BOOK_DETAIL UNION SELECT BkBankAccCode FROM PAYMENT_BANK_BOOK_DETAIL UNION SELECT BkTDSPartyCode FROM PAYMENT_BANK_BOOK_ADDLESS_DETAIL UNION SELECT BkAccCode FROM PAYMENT_CASH_BOOK_DETAIL UNION SELECT BkCashAccCode FROM PAYMENT_CASH_BOOK_DETAIL UNION SELECT BkAccCode FROM RECEIVED_BANK_BOOK_DETAIL UNION SELECT JobCode FROM CHALLAN_RECEIVED_FROM_JOB UNION 
                SELECT PartyCode FROM OUTWARD_CHALLAN UNION SELECT BkBankAccCode FROM RECEIVED_BANK_BOOK_DETAIL UNION SELECT BkAccCode FROM BANK_BOOK_CHEQUE_RETURN_DETAIL UNION SELECT BkBankAccCode FROM BANK_BOOK_CHEQUE_RETURN_DETAIL UNION SELECT BkAccCode FROM RECEIVED_CASH_BOOK_DETAIL UNION SELECT BkCashAccCode FROM RECEIVED_CASH_BOOK_DETAIL UNION SELECT JobCode FROM SEND_TO_JOB UNION SELECT JobCode FROM OPENING_SEND_TO_JOB UNION SELECT ItemAccCode FROM SEND_TO_JOB_ITEM_DETAIL UNION SELECT ItemAccCode FROM LACE_LINING_ITEM_DETAIL UNION SELECT ItemAccCode FROM OPENING_SEND_TO_JOB_ITEM_DETAIL UNION SELECT JobCode FROM RECEIVED_FROM_JOB UNION SELECT JobCode FROM OPENING_RECEIVED_FROM_JOB UNION SELECT AccCode FROM BILL_ACCOUNT_TYPES UNION SELECT AccCode FROM FINISHED_PURCHASE_ACCOUNT_TYPES UNION SELECT AccCode FROM RECEIVED_FROM_JOB_ACCOUNT_TYPES UNION 
                SELECT AccCode FROM OTHER_PURCHASE_ACCOUNT_TYPES UNION SELECT PurType FROM RECEIVED_FROM_JOB UNION SELECT PurType FROM OPENING_RECEIVED_FROM_JOB UNION SELECT PartyCode FROM TDS_TCS_CHALLAN_PARTY_DETAIL UNION SELECT SaleType FROM OUTWARD_DETAIL UNION SELECT SaleType FROM OUTWARD_CHALLAN UNION SELECT AccCode FROM Bill_ACCOUNT_TYPES UNION SELECT AccCode FROM OTHER_PURCHASE_ACCOUNT_TYPES
                UNION SELECT SuppCode FROM OPENING_GENERAL_PURCHASE
                )
USE COMMONE 
delete FROM account_master