a guest Jan 22nd, 2019 54 Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1. SELECT  o.imeo, o.przo, z.policajac_rad_mbr,p.rad_ime,p.rad_prz, gp.nazgp, COUNT(z.mbrz) AS br_zivotinja
  2.         FROM ((osoba o INNER JOIN zivotinja z ON o.jmbg = z.osoba_jmbg) INNER JOIN policajac p ON p.rad_mbr = z.policajac_rad_mbr)
  3.            INNER JOIN granicni_prelaz gp ON gp.idgp = p.id_prelaz GROUP BY  o.imeo, o.przo, z.policajac_rad_mbr, gp.nazgp,p.rad_ime, p.rad_prz
  4.                 HAVING COUNT(z.mbrz) > 1;
RAW Paste Data
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy. OK, I Understand