Posted by Nancy on 10/07/06 17:02

I keep getting a syntax errorr with this code and having problems
figuring out the problem.

SELECT pageid, title, section.name, category.name, subcat.name,
division.name, subdiv.name
FROM page
LEFT JOIN(section, category, subcat, division, subdiv)
ON (section.section id = page.sectionid AND
category.categoryid = page.categoryid AND
subcat.subcatid = page.subcatid AND
division.divisionid = page.divisionid AND
subdiv.subdivid = page.subdivid)
WHERE authorid=$seq

The errorr occurrs when I attempt to join the tables after the 'ON'
statement.
Thanks for any help

[Back to original message]