Predmet:Re: Update i Sum
Probaj ovo
PreuzmiIzvorni kôd (SQL):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);
Ne koristi razmake u naivima tabela i polja
Kod uslova Like '03*9*' vodi racuna da * menja proizvoljan broj charactera, a ? samo jedan