Evo ga konačan upit:
Kôd:
SELECT * FROM profesori p INNER JOIN profpred pp ON p.id = pp.idprof
INNER JOIN predsmer ps ON pp.idpred = ps.idpred
WHERE ps.idsmer = zeljeni_smer_id
GROUP BY p.id;
Samo sam dodao jos "GROUP BY p.id" da izbaci duplikate!
Tnx