UPDATE [bilans aop arhiva stanja] AS TS SET TS.[ispravka vrijednosti] = Round((SELECT Sum(S1.Potrazuje) FROM Stavgk AS S1 WHERE (S1.firmaID = TS.firma_ID) AND (S1.konto Like '03*9*')) - (SELECT Sum(S2.Potrazuje) FROM Stavgk As S2 WHERE (S2.firmaID = TS.firma_ID) AND (S2.konto Like '03*9*'))) WHERE (TS.godina=2014) AND (TS.ObracinskiPeriod='godisnji') AND (TS.aop=14);