Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- SELECT o.imeo, o.przo, z.policajac_rad_mbr,p.rad_ime,p.rad_prz, gp.nazgp, COUNT(z.mbrz) AS br_zivotinja
- 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)
- 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
- HAVING COUNT(z.mbrz) > 1;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement