USE t24y001



SELECT * FROM SCAN_BALANCE_SHEET WHERE (CREDITACC='' OR DEBITACC='') AND AMOUNT <>0

SELECT * FROM SCAN_BALANCE_SHEET WHERE (CREDITACC=DEBITACC) AND AMOUNT <>0

SELECT * FROM SCAN_BALANCE_SHEET WHERE CREDITACC NOT IN (SELECT ACCCODE FROM ACCOUNT_MASTER)
SELECT * FROM SCAN_BALANCE_SHEET WHERE DEBITACC NOT IN (SELECT ACCCODE FROM ACCOUNT_MASTER)

SELECT * FROM SCAN_BALANCE_SHEET WHERE CREDITACC NOT IN (SELECT ACCCODE FROM COMMON.DBO.ACCOUNT_MASTER)
SELECT * FROM SCAN_BALANCE_SHEET WHERE DEBITACC NOT IN (SELECT ACCCODE FROM COMMON.DBO.ACCOUNT_MASTER)

SELECT * FROM ACCOUNT_MASTER WHERE ACCTYPE NOT IN (SELECT ACCTYPES FROM ACCOUNT_TYPES)
SELECT * FROM ACCOUNT_MASTER WHERE ACCTYPE NOT IN (SELECT ACCTYPES FROM COMMON.DBO.ACCOUNT_TYPES)

SELECT * FROM TDS_TYPE_MASTER SELECT * FROM COMMON.DBO.TDS_TYPE_MASTER

SELECT * FROM COMMON.DBO.ACCOUNT_TYPES WHERE ACCTYPES NOT IN (SELECT ACCTYPES FROM T25R001.DBO.ACCOUNT_TYPES)

SELECT * FROM account_master WHERE ACCTYPE=''


SELECT * FROM SCAN_BALANCE_SHEET ORDER BY TDATE

SELECT * FROM PAYMENT_BANK_BOOK_DETAIL WHERE BKSRNO NOT IN (SELECT BKSRNO FROM PAYMENT_BANK_BOOK_ADDLESS_DETAIL)
SELECT * FROM RECEIVED_BANK_BOOK_DETAIL WHERE BKSRNO NOT IN (SELECT BKSRNO FROM RECEIVED_BANK_BOOK_ADDLESS_DETAIL)

SELECT * FROM PAYMENT_CASH_BOOK_DETAIL WHERE BKSRNO NOT IN (SELECT BKSRNO FROM PAYMENT_CASH_BOOK_ADDLESS_DETAIL)
SELECT * FROM RECEIVED_CASH_BOOK_DETAIL WHERE BKSRNO NOT IN (SELECT BKSRNO FROM RECEIVED_CASH_BOOK_ADDLESS_DETAIL)