Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- select distinct d
- from ProfessorTurma pt
- join fetch pt.turma t
- join fetch t.disciplina d
- where pt.idprofessor = ?
- and t.podelancarnota = 1
- and t.idturmateorica is null
- and t.status != 9
- and t.anosemestre = ?
- order by d.nome;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement