UPDATE       [TRANSACTION]
SET                GOID = T_Forosh.GOID, KOLID = T_Forosh.KOLID, THESABID = T_Forosh.THESABID, HESABID = T_Forosh.HesabID, OperationCode = T_Forosh.ForoshNumbr, SAID2Number = T_SA2.SAID2Number, Date1 = T_Forosh.DateFo, 
                         Dateeng = T_Forosh.Dateeng, FieldN2 = T_SA2.SAID2, Tedad1 = [TRANSACTION].TedadFo
FROM            [TRANSACTION] INNER JOIN
                         T_Forosh ON [TRANSACTION].FOROSHID = T_Forosh.FOROSHID INNER JOIN
                         T_SA2 ON T_Forosh.PrimarySaid2 = T_SA2.SAID2
WHERE        (NOT ([TRANSACTION].KALAID IS NULL)) AND ([TRANSACTION].KOLID IS NULL)

GO
