ESTOU TENTANDO EXECUTAR CONSULTA ABAIXO E ESTÁ DANDO A SEGUINTE MENSAGEM DE ERRO: "ERRO NA EXECUÇÃO DO SQL. GENERAL SQL ERROR: CANNOT CALL METHODS ON VARCHAR"
----->
SELECT EALUNOS.MATRICULA, EALUNOS.NOME, EALUNOS.STATUS, EDISCIPLINAS.MATERIA,
EALUNOTPR.PERLETIVO, ESITMAT.ATIVO, EALUNOTPR.CODCUR, EALUNOTPR.P1, EALUNOTPR.P2, EALUNOTPR.P3, EALUNOTPR.P4, EALUNOTPR.P5,EALUNOTPR.P6,EALUNOTPR.P7,EALUNOTPR.P8, EALUNOTPR.P9, EALUNOTPR.P10, EALUNOTPR.P11, EALUNOTPR.P12, esitmat.prxstalu, EMATALUNO.A1, EMATALUNO.A3, EMATALUNO.A6, EMATALUNO.A7, EMATALUNO.A8, EMATALUNO.A9, ETURMISTA.CODMAT, ETURMISTA.CODTURMISTA. ETURMISTA.NOMETURMISTA
FROM Ealunotpr LEFT OUTER JOIN EALUNOS ON
(((EALUNOTPR.CODCOLIGADA = EALUNOS.CODCOLIGADA) AND (EALUNOTPR.MATALUNO = EALUNOS.MATRICULA)))
LEFT OUTER JOIN EGRADE ON
(((EALUNOTPR.CODCUR = EGRADE.CODCUR) AND
(EALUNOTPR. CODPER = EGRADE. CODPER) AND
(EALUNOTPR.CODMAT = EGRADE. CODMAT) AND (EALUNOTPR.PERLETIVO=EGRADE.CODPERLET) AND (EALUNOTPR.CODCOLIGADA=EGRADE.CODCOLIGADA)))
LEFT OUTER JOIN EDISCIPLINAS ON (((EDISCIPLINAS.CODMAT=EGRADE.CODMAT)))
LEFT OUTER JOIN ESITMAT ON
(((EALUNOS.STATUS = ESITMAT.CODSITMAT)))
LEFT OUTER JOIN EMATALUNO ON
(((EALUNOTPR.CODCOLIGADA = EMATALUNO.CODCOLIGADA)
AND (EALUNOTPR.CODFILIAL = EMATALUNO. CODFILIAL)
AND (EALUNOTPR.PERLETIVO = EMATALUNO. PERLETIVO)
AND (EALUNOTPR. CODCUR = EMATALUNO.CODCUR)
AND (EALUNOTPR. CODPER = EMATALUNO.CODPER)
AND (EALUNOTPR. CODTUN = EMATALUNO.CODTUN)
AND (EALUNOTPR.CODTUR = EMATALUNO.CODTUR)
AND (EALUNOTPR.MATALUNO = EMATALUNO.MATALUNO)
AND (EALUNOTPR.CODMAT = EMATALUNO.CODMAT)))
LEFT OUTER JOIN ETURMISTA ON
(((EALUNOTPR.CODMAT = ETURMISTA.CODMAT)))
<-------
*** Textos com links removidos !!!!! ***