When i do this in SQL server runs, but when step to the code it gives me this message “The multi -part identifier” AVALIACAO_ALUNO.AVAL_VALOR “could not be bound”.
SELECT
CONVERT(INT, AVALIACAO_ALUNO.AVAL_VALOR) NOTA, PARAM_AVALIACAO.PARAM_DESCR
FROM
DISCIPLINA_CURSO
INNER JOIN DISCIPLINA on (dc_cod_disp=DISCIPLINA.DIS_COD_DISCIPLINA)
INNER JOIN AVALIACAO_ALUNO on (AVAL_COD_ALUNO=802 AND AVAL_COD_TURMA=152 AND AVAL_COD_DISC=DISCIPLINA.DIS_COD_DISCIPLINA)
LEFT JOIN PARAM_AVALIACAO on (PARAM_AVALIACAO.param_tipo_curso=AVALIACAO_ALUNO.AVAL_COD_DISC and PARAM_AVALIACAO.param_id=AVALIACAO_ALUNO.aval_cod_param)
WHERE
dc_cod_curso=11