[Microsoft][Pilote ODBC Microsoft Access] Expression JOIN non support?e.
LEFT JOIN (select SUM(note) FROM NOTES,DISCIPLINE where DISCIPLINE.code_dis=NOTES.code_dis " + "AND DISCIPLINE.nom_dis='mathematique')" + " ELEVE ON ELEVE.code_eleve=TEST_ELEVE.code_eleve)
SELECT ..., (SELECT ... ) AS NomChamp, ... FROM ...
RIGHT JOIN ELEVE ON ELEVE.code_eleve=TEST_ELEVE.code_eleve
LEFT JOIN (select SUM(note) FROM NOTES,DISCIPLINE where DISCIPLINE.code_dis=NOTES.code_dis AND DISCIPLINE.nom_dis='mathematique') ELEVE ON ELEVE.code_eleve=TEST_ELEVE.code_eleve
LEFT JOIN (select code_Eleve, SUM(note) FROM NOTES,DISCIPLINE where DISCIPLINE.code_dis=NOTES.code_dis AND DISCIPLINE.nom_dis='mathematique' group by code_eleve) NOTES_ELEVE ON NOTES_ELEVE.code_eleve=TEST_ELEVE.code_eleve
Vous n’avez pas trouvé la réponse que vous recherchez ?
Posez votre question