USE E24A001 UPDATE ACCOUNT_MASTER SET ACCTYPE='UNSECURED LOAN' WHERE acctype = 'BANK ACCOUNT' AND ACCCODE COLLATE DATABASE_DEFAULT NOT IN (SELECT creditacc FROM TMP_SCAN_BALANCE_SHEET UNION SELECT DEBITACC FROM TMP_SCAN_BALANCE_SHEET)
USE E24A001 UPDATE ACCOUNT_MASTER SET ACCTYPE='UNSECURED LOAN' WHERE acctype = 'BANK ACCOUNT' AND ACCCODE COLLATE DATABASE_DEFAULT NOT IN (SELECT creditacc FROM TMP_SCAN_BALANCE_SHEET UNION SELECT DEBITACC FROM TMP_SCAN_BALANCE_SHEET)