Predmet:Re: Prikaz stanja racuna po bankama
Evo SQL.
Prekopiraj uQuery
PreuzmiIzvorni kôd (SQL):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;
Podrška samo putem foruma, jer samo tako i ostali imaju koristi od toga.