je n'arrive pas à trouver l'erreur que je fais dans cette requête :
SELECT
EssaiMachine.IDEssai AS IDEssai,
EssaiMachine.IDRole AS IDRole,
EssaiMachine.IDEssaiMachine AS IDEssaiMachine,
EssaiMachine.IDConfiguration AS IDConfiguration,
EssaiMachine.Rectangle AS Rectangle,
Machine.Nom AS Nom_Machine,
TypeRole.Libelle AS Libelle,
Configuration.Nom AS Nom_Configuration,
Machine.URLImage AS URLImage,
EssaiMachine.IDScenario AS IDScenario,
EssaiMachine.IDSecurite AS IDSecurite,
EssaiMachine.IDEquipement AS IDEquipement,
Scenario.Nom AS Nom_Scenario,
Securite.Nom AS Nom_Securite,
Equipement.Nom AS Nom_Equipement,
Essai.Nom AS Nom
FROM
RIGHT OUTER JOIN EssaiMachine ON Equipement.IDEquipement = EssaiMachine.IDEquipement,
INNER JOIN EssaiMachine ON Essai.IDEssai = EssaiMachine.IDEssai,
RIGHT OUTER JOIN EssaiMachine ON Configuration.IDConfiguration = EssaiMachine.IDConfiguration,
RIGHT OUTER JOIN EssaiMachine ON Securite.IDSecurite = EssaiMachine.IDSecurite,
RIGHT OUTER JOIN EssaiMachine ON Scenario.IDScenario = EssaiMachine.IDScenario,
INNER JOIN EssaiMachine ON Role.IDRole = EssaiMachine.IDRole,
INNER JOIN Role ON Machine.IDMachine = Role.IDMachine,
INNER JOIN Role ON TypeRole.CodeTypeRole = Role.CodeTypeRole
WHERE
(
EssaiMachine.IDEssai = {pIDEssai}
AND TypeRole.CodeLangue = {pCodeLangue}
);
Quand je la lance dans MySQL, cette erreur s'affiche :
ERROR 1064 <42000>: You have an error in your SQL syntax; check the manual that correspond to your MySQL server version for right syntax to use near 'RIGHT OUTER JOIN EssaiMachine ON Equipement.IDEquipement = EssaiMachine.IDEquipe' at line 19
Le problème parait long comme ça mais si quelqu'un pouvait m'aider ^^
