MySQL LEFT JOIN error
- by Alex
Hello,
I've got some SQL that used to work with an older MySQL version, but after upgrading to a newer MySQL 5 version, I'm getting an error. Here's the SQL:
SELECT portfolio.*, projects.*, types.*
FROM projects, types
LEFT JOIN portfolio
ON portfolio.pfProjectID = projects.projectID
WHERE projects.projectType = types.typeID AND types.typeID = #URL.a#
ORDER BY types.typeSort, projects.projectPriority ASC
and the new error I'm receiving:
Unknown column 'projects.projectID' in 'on clause'
How can I convert this to compatible SQL for the newer MySQL version?
Thanks very much!