SELECT
    am.CDU_Aluno AS AlunoMatricula,
    amd.CDU_Aluno AS AlunoDisciplina,
    am.CDU_NumInscricao AS InscricaoMatricula,
    --amd.CDU_NumInscricao AS InscricaoDisciplina,
    s.CDU_Situacao as 'SituacaoMatricula',
    s.CDU_Descricao as 'DescricaoSituacaoMatricula',
    s.CDU_Activo as 'Matricula Ativa',
    am.CDU_AnoLectivo AS AnoLetivoMatricula,
    --amd.CDU_AnoLectivo AS AnoLetivoDisciplina,
    am.CDU_AnoGrau AS AnoGrauMatricula,
    amd.CDU_AnoGrau AS AnoGrauDisciplina,
    cast((CASE WHEN isnull(am.CDU_AnoGrau,'')<> isnull(amd.CDU_AnoGrau,'') THEN 1 ELSE 0 END) as bit) 'AnoGrauInvalido',
    am.CDU_Curso AS CursoMatricula,
    amd.CDU_Curso AS CursoDisciplina,
    cast((CASE WHEN isnull(am.CDU_Curso,'')<> isnull(amd.CDU_Curso,'') THEN 1 ELSE 0 END) as bit) 'CursoInvalido',
    amd.CDU_Disciplina AS Disciplina,
    td.CDU_Disciplina AS DisciplinaTurmaDisciplina,
    cast
    (
        (CASE WHEN (am.CDU_Turma is not null) AND isnull(amd.CDU_Disciplina,'')<> isnull(td.CDU_Disciplina,'') THEN 1 ELSE 0 END) as bit
    ) 'DisciplinaInvalida',
    am.CDU_Turma AS TurmaMatricula,
    t.CDU_Turma AS Turma,
    t.CDU_AnoGrau AS AnoGrauTurma,
    t.CDU_AnoLectivo AS AnoLetivoTurma,
    t.CDU_Curso AS CursoTurma,
    td.CDU_AnoLectivo AS AnoLetivoTurmaDisciplina,
    td.CDU_AnoGrau AS AnoGrauTurmaDisciplina,
    td.CDU_Turma AS TrumaTurmaDisciplina
FROM
    TDU_AlunoMatriculas am WITH(NOLOCK)
    LEFT JOIN TDU_AlunoMatriculaDisciplinas amd WITH(NOLOCK)
        ON am.CDU_NumInscricao = amd.CDU_NumInscricao AND am.CDU_Aluno = amd.CDU_Aluno AND am.CDU_AnoLectivo = amd.CDU_AnoLectivo
    LEFT JOIN TDU_TurmaAlunos ta WITH(NOLOCK)
        ON ta.CDU_AnoLectivo = am.CDU_AnoLectivo AND ta.CDU_AnoGrau = amd.CDU_AnoGrau AND ta.CDU_Aluno = am.CDU_Aluno
    LEFT JOIN TDU_TurmaDisciplinas td WITH(NOLOCK)
        ON td.CDU_AnoLectivo = amd.CDU_AnoLectivo AND td.CDU_AnoGrau = amd.CDU_AnoGrau AND td.CDU_Disciplina = amd.CDU_Disciplina and td.CDU_Turma = ta.CDU_Turma
    LEFT JOIN TDU_Turmas t WITH(NOLOCK) ON
        am.CDU_AnoLectivo = t.CDU_AnoLectivo AND t.CDU_Turma = td.CDU_Turma
    LEFT JOIN TDU_Situacoes s WITH(NOLOCK) ON
        s.CDU_Situacao = am.CDU_Situacao
    WHERE
        am.CDU_AnoLectivo = '2018/2019'
        --and am.CDU_Aluno = '3442'