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;