To ti je to, samo sve to spojiš u jedan upit i ne treba ti povezivanje sa tabelom Artikli pošto iz nje ništa ne uzimaš:
Code:
SELECT query1.artikal AS sifra, query1.sum1, query2.sum2
FROM (SELECT artikal, SUM(kolicina*cijena) AS sum1
FROM ulazi
GROUP BY artikal
) AS query1
INNER JOIN
(SELECT artikal, SUM(kolicina*cijena) AS sum2
FROM izlazi
GROUP BY artikal
) AS query2
ON query1.artikal = query2.artikal
ORDER BY query1.artikal;
Ovde je verovatno prikladnije LEFT OUTER JOIN umesto INNER JOIN-a.
"The best code is no code at all."
- Zidar (ES član)
"Biggest obstacle to learning
SQL is unlearning procedural
programming." - Joe
Celko
"Minimize code, maximize data."
- A. Neil Pappalardo