Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- SELECT SUM(iz.kolicina) FROM RobnaStavka iz
- INNER JOIN iz.robniDokument AS dok "
- + " INNER JOIN iz.artikl AS art"
- + " INNER JOIN iz.skladiste AS vl "
- + " INNER JOIN dok.sifranikDokumenta AS sifDok "
- + " WHERE dok.korisnik=:kor "
- + " AND vl.slozenaSifra IN (:sifs) " + " AND art.id=:artId "
- + " AND iz.rezerviraKolicinu=TRUE "
- + " AND dok.STATUS < :STATUS " + " AND dok.STATUS >= 0 "
- + " AND (iz.vrstaStavke='"
Add Comment
Please, Sign In to add comment