Guest User

Untitled

a guest
Jan 12th, 2018
88
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
SQL 0.45 KB | None | 0 0
  1. SELECT SUM(iz.kolicina) FROM RobnaStavka iz
  2.                 INNER JOIN iz.robniDokument AS dok "
  3.                 + " INNER JOIN iz.artikl AS art"
  4.                 + " INNER JOIN iz.skladiste AS vl "
  5.                 + " INNER JOIN dok.sifranikDokumenta AS sifDok "
  6.                 + " WHERE dok.korisnik=:kor "
  7.                 + " AND vl.slozenaSifra IN (:sifs)  " + " AND art.id=:artId "
  8.                 + " AND iz.rezerviraKolicinu=TRUE "
  9.                 + " AND dok.STATUS < :STATUS " + " AND dok.STATUS >= 0 "
  10.                 + " AND (iz.vrstaStavke='"
Add Comment
Please, Sign In to add comment