[jablan]

Pa i nije ti nešto složen upit:

SELECT ime, prezime
FROM PROFESORI p
INNER JOIN PROFPRED pp ON p.id = pp.idprof
INNER JOIN PREDSMER ps ON pp.idpred = ps.idpred
WHERE ps.idsmer = zadatismer