Do you have a question? Post it now! No Registration Necessary. Now with pictures!
- Posted on
- Syntax errorr
October 7, 2006, 5:02 pm
rate this thread
figuring out the problem.
SELECT pageid, title, section.name, category.name, subcat.name,
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)
The errorr occurrs when I attempt to join the tables after the 'ON'
Thanks for any help
Re: Syntax errorr
You might have more luck asking about SQL problems on an SQL group
rather than a PHP one.
But, to have a go - the answer depends on which version of which SQL you
Because, for example,
LEFT JOIN (table, table, ... )
is not supported in MySQL before V5.0, nor (if I read the documentation
correctly) in any version of PostgresQL.