UPDATE ACCOUNT_MASTER Set GSTIN = T1.F2, CompScheme=T1.F3, GSTCategory=T1.F4, ECommGSTIN=T1.F5, GSTRegDate=T1.F6 FROM (SELECT AccCode AS F1, GSTIN AS F2, CompScheme AS F3, GSTCategory AS F4, ECommGSTIN AS F5, GSTRegDate AS F6 FROM COMMON.DBO.ACCOUNT_MASTER) AS T1 WHERE T1.F1 COLLATE DATABASE_DEFAULT = AccCode AND GSTIN=''
UPDATE AGENT_MASTER Set GSTIN = T1.F2, CompScheme=T1.F3 FROM (SELECT AgentCode AS F1, GSTIN AS F2, CompScheme AS F3 FROM COMMON.DBO.AGENT_MASTER) AS T1 WHERE T1.F1 COLLATE DATABASE_DEFAULT = AgentCode AND GSTIN=''
UPDATE HASTE_MASTER Set GSTIN = T1.F2, CompScheme=T1.F3 FROM (SELECT Haste AS F1, GSTIN AS F2, CompScheme AS F3 FROM COMMON.DBO.HASTE_MASTER) AS T1 WHERE T1.F1 COLLATE DATABASE_DEFAULT = Haste AND GSTIN=''