SELECT tblBanka.BrojRa

una, SUM(tblNovacUlaz.NetoIznos) AS IznosUlaza, SUM([Kolicina]*[cena]) AS IZnosIzlaza, SUM([NetoIznos])-SUM([Kolicina]*[Cena]) AS Stanje

FROM ((tblBanka INNER JOIN tblNovacIzlaz ON tblBanka.ID_Ra

unBanke = tblNovacIzlaz.ID_Ra

unBanke) INNER JOIN tblNovacUlaz ON tblBanka.ID_Ra

unBanke = tblNovacUlaz.ID_Ra

unBanke) INNER JOIN tblNovacIzlazRacun ON tblNovacIzlaz.ID_Ra

un = tblNovacIzlazRacun.ID_Ra

un

GROUP BY tblBanka.BrojRa

una;