Report Offensive Message

SYNTAX for SQL JOIN?
Ok, I am trying to figure out the syntax for a multiple table SQL nested JOIN, and I am either getting syntax errors or the latest: "Too many fields" error. I cannot find what is wrong. Here is the query I am trying to get right:

SELECT EE_REPORT_DATA1.*, EE_REPORT_DATA2.*, EE_REPORT_DATA3.*
FROM ((EE_REPORT_DATA1 INNER JOIN EE_REPORT_DATA2 ON EE_REPORT_DATA1.ID = EE_REPORT_DATA2.CHILDID2) INNER JOIN EE_REPORT_DATA3 ON EE_REPORT_DATA3.CHILDID3 = EE_REPORT_DATA1.ID)
WHERE EE_REPORT_DATA1.ID = vRPT_ID;

Any clues?

Thanks,

John
Posted by strannik@...
5th Dec 2007