Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- $sql = ' SELECT MAT.CODIGO, MAT.COD_CURSO, MAT.CURSO FROM
- (SELECT M.CODIGO, M.COD_CURSO, C.CURSO FROM
- (SELECT CODIGO, COD_CURSO FROM MATRICULA WHERE COD_ALUNO = :PCOD_ALUNO) AS M
- LEFT OUTER JOIN CURSO C ON M.COD_CURSO = C.CODIGO
- UNION
- SELECT ME.CODIGO, ME.COD_CURSO, C.CURSO FROM
- (SELECT CODIGO, COD_CURSO FROM MATRICULAEJA WHERE COD_ALUNO = :PCOD_ALUNO_EJA) AS ME
- LEFT OUTER JOIN CURSO C ON ME.COD_CURSO = C.CODIGO) AS MAT
- ORDER BY MAT.CURSO';
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement