UPDATE SEND_TO_JOB SET GSTSupplyType = 'UNREGISTERED' 
UPDATE SEND_TO_JOB SET GSTSupplyType = 'REGISTERED' WHERE JobCode IN (SELECT AccCode FROM ACCOUNT_MASTER WHERE GSTIN <> '')

UPDATE CHALLAN_RECEIVED_FROM_JOB SET GSTSupplyType = 'UNREGISTERED' 
UPDATE CHALLAN_RECEIVED_FROM_JOB SET GSTSupplyType = 'REGISTERED' WHERE JobCode IN (SELECT AccCode FROM ACCOUNT_MASTER WHERE GSTIN <> '')

UPDATE GREY_SEND_TO_MILL SET GSTSupplyType = 'UNREGISTERED' 
UPDATE GREY_SEND_TO_MILL SET GSTSupplyType = 'REGISTERED' WHERE MillCode IN (SELECT AccCode FROM ACCOUNT_MASTER WHERE GSTIN <> '')

UPDATE FINISHED_RECEIVED_FROM_MILL SET GSTSupplyType = 'UNREGISTERED' 
UPDATE FINISHED_RECEIVED_FROM_MILL SET GSTSupplyType = 'REGISTERED' WHERE MillCode IN (SELECT AccCode FROM ACCOUNT_MASTER WHERE GSTIN <> '')