Pretpostavimo da imas tabele i polja u njima: tblIzlaznaFaktura (fldPorez); tblPlata (fldIznos); tblUlaznaFaktura (fldVrednost) - ovo je za primer, ja tabele i polja ne nazivam po prethodnom principu. Dakle, hoces da iskazes sume na jednoj izvestaju, a te sume nisu nicim povezane. To znaci da ih moras vestacki povezati, a ja cu ti dati 2 primera kako to mozes da uradis.
Primer 1
Code:
SELECT SUM(Porez) AS TPorez, SUM(Plate) AS TPlate, SUM(Nabavka) AS TNabavka
FROM
(SELECT SUM(fldPorez) AS Porez, 0 AS Plate, 0 AS Nabavka FROM tblIzlaznaFaktura
UNION ALL
SELECT 0 AS Porez, SUM(fldIznos) AS Plate, 0 AS Nabavka FROM tblPlata
UNION ALL
SELECT 0 AS Porez, 0 AS Plate, SUM(fldVrednost) AS Nabavka FROM tblUlaznaFaktura) AS Unija
Primer 2
Code:
SELECT Porez, Plate, Nabavka FROM
((SELECT SUM(fldPorez) AS Porez, 1 AS Veza FROM tblIzlaznaFaktura) AS IFak
INNER JOIN (SELECT SUM(fldIznos) AS Plate, 1 AS Veza FROM tblPlata) AS Plate ON IFak.Veza = Plate.Veza)
INNER JOIN (SELECT SUM(fldVrednost) AS Nabavka, 1 AS Veza FROM tblUlaznaFaktura) AS UFak ON IFak.Veza = UFak.Veza
Izvini ako ne radi iz prve, pisao sam sve iz glave, ali poenta je u konceptu, greske ces lako ispraviti.