SELECT DISTINCT FORMSRNO FROM FIRM_ADDLESS_DETAIL WHERE FORMNAME='SALE BILL' AND EffAcc='SALEA/C' UPDATE FIRM_ADDLESS_DETAIL SET AccEff='NO', EFFACC='' WHERE FORMNAME='SALE BILL' AND EffAcc='SALEA/C'
SELECT DISTINCT FORMSRNO FROM FIRM_ADDLESS_DETAIL WHERE FORMNAME='SALE BILL' AND EffAcc='SALEA/C' UPDATE FIRM_ADDLESS_DETAIL SET AccEff='NO', EFFACC='' WHERE FORMNAME='SALE BILL' AND EffAcc='SALEA/C'