Perhaps somebody has the suggestion for the following problem. For some reason the following query fails in MySQL:
SELECT * FROM Table1 INNER JOIN
(Table2 INNER JOIN Table3
ON Table2.Child_ID = Table3.Primary_ID) ON Table1.Primary_ID=Table2.Parent_ID;
with this error message:
You have an error in your SQL syntax near '(AnswersToPolls INNER JOIN Answers ON AnswersToPolls.Child_ID=Answers.A
nswer_ID)' at line 1
This query works fine in MS Access, and I'm completely at loss for the cause.
SELECT * FROM Table1 INNER JOIN
(Table2 INNER JOIN Table3
ON Table2.Child_ID = Table3.Primary_ID) ON Table1.Primary_ID=Table2.Parent_ID;
with this error message:
You have an error in your SQL syntax near '(AnswersToPolls INNER JOIN Answers ON AnswersToPolls.Child_ID=Answers.A
nswer_ID)' at line 1
This query works fine in MS Access, and I'm completely at loss for the cause.