The multi-part identifier "AVALIACAO_ALUNO.AVAL_VALOR" could not be bound

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

And you’re sure the column AVAL_VALOR exists in the table AVALIACAO_ALUNO ?

Yes dude.
problem is solved , the issue was that I had another query in an if to destinção and it was not necessary to be there.

Thanks

1 Like

This topic was automatically closed 91 days after the last reply. New replies are no longer allowed.