Rev 1283 | Blame | Compare with Previous | Last modification | View Log | RSS feed
Ler docentes de uma disciplina e Turmas
SELECT DISTINCT CSE.T_TBDISCIP.CD_DISCIP AS CD_DISCIP, CSD.T_DOC_TURMA.CD_TURMA AS CD_TURMA, CSD.T_DOC_TURMA.CD_LECTIVO, CD_DURACAO, CD_CURSO, CSD.T_DOC_TURMA.CD_DOCENTE FROM ((CSD.T_DOC_TURMA INNER JOIN CSE.T_TBDISCIP ON CSE.T_TBDISCIP.CD_DISCIP = CSD.T_DOC_TURMA.CD_DISCIP) INNER JOIN CSH.T_DETALHE_AULA ON CSH.T_DETALHE_AULA.CD_DOCENTE = CSD.T_DOC_TURMA.CD_DOCENTE AND CSH.T_DETALHE_AULA.CD_DISCIP = CSE.T_TBDISCIP.CD_DISCIP) WHERE CSD.T_DOC_TURMA.CD_LECTIVO=201415 AND CSE.T_TBDISCIP.CD_INSTITUIC=4 AND CSE.T_TBDISCIP.CD_DISCIP=704320;
Ler alunos de uma disciplina