Horarios das Turmas.sql

SELECT
    TD.CODDISC,
    D.NOME AS DISCIPLINA,
    C.CODCURSO,
    C.NOME AS CURSO,
    TD.IDTURMADISC,
    TD.CODTURMA,
    ST.CODSUBTURMA,
    PL.CODPERLET,
    H.DIASEMANA,
    H.HORAINICIAL,
    H.HORAFINAL,
    HT.DATAINICIAL,
    HT.DATAFINAL
FROM
    STURMADISC TD ( NOLOCK )
    LEFT JOIN SSUBTURMA ST ( NOLOCK )
        ON TD.CODCOLIGADA = ST.CODCOLIGADA
           AND TD.IDTURMADISC = ST.IDTURMADISC
    JOIN SDISCIPLINA D ( NOLOCK )
        ON TD.CODCOLIGADA = D.CODCOLIGADA
           AND TD.CODDISC = D.CODDISC
    JOIN SHORARIOTURMA HT ( NOLOCK )
        ON TD.CODCOLIGADA = HT.CODCOLIGADA
           AND TD.IDTURMADISC = HT.IDTURMADISC
    JOIN SHORARIO H ( NOLOCK )
        ON HT.CODCOLIGADA = H.CODCOLIGADA
           AND HT.CODHOR = H.CODHOR
    JOIN SPLETIVO PL ( NOLOCK )
        ON TD.CODCOLIGADA = PL.CODCOLIGADA
           AND TD.IDPERLET = PL.IDPERLET
    JOIN SHABILITACAOFILIAL HF ( NOLOCK )
        ON TD.CODCOLIGADA = HF.CODCOLIGADA
           AND TD.IDHABILITACAOFILIAL = HF.IDHABILITACAOFILIAL
    JOIN SCURSO C ( NOLOCK )
        ON C.CODCOLIGADA = HF.CODCOLIGADA
           AND C.CODCURSO = HF.CODCURSO
           AND C.CODTIPOCURSO = 2
ORDER BY
    PL.CODPERLET,
    D.NOME,
    H.DIASEMANA,
    H.HORAINICIAL