select doc.id, doc.nome from (select id from descrDesignaCicloEstudos where codigo=) descDesign inner join (select idDescrDesignaCiclo, idUC from planos_ucs where id_anoletivo=5) planos on descDesign.id=planos.idDescrDesignaCiclo inner join (select idUC, idDocente from inscricaoAlunoDocenteUC where id_anoLetivo=5) docDSANO on planos.idUC=docDSANO.idUC inner join (select id,nome from docente ) doc on docDSANO.idDocente=doc.id group by doc.id order by doc.nome

select doc.id, doc.nome, planos.idUC, ucs.nome as nomeUCS,ucs.codigoCurso from (select id from descrDesignaCicloEstudos where codigo=) descDesign inner join (select idDescrDesignaCiclo, idUC from planos_ucs where id_anoletivo=5) planos on descDesign.id=planos.idDescrDesignaCiclo inner join (select idUC, iddoc from docDS where idAno=5) docDSANO on planos.idUC=docDSANO.idUC inner join (select id,nome from docente ) doc on docDSANO.iddoc=doc.id inner join (select id, nome,codigoCurso from UC )ucs on ucs.id=planos.idUC group by doc.id order by doc.nome ASC



Aulas indididual

array(0) { }


Aulas coletiva

array(0) { }


todos

array(0) { }

Informação indisponível