Re: MySQL 4 to MySQL 5 - SQL syntax question.

[Scott Gurley]

One thing I keep running into upgrading from MySQL4 to MySQL5 is a difference in LEFT JOIN... for example

SELECT users.name, department.name as department, countries.name as country FROM users, departments LEFT JOIN countries on users.country = countries.uid

[I'm faking this as I type - ignore any typos)

The above WILL work in MySQL4 but not in MySQL5! I'm not sure why it is different but to get it working in MySQL5 the above query needs to be:

SELECT users.name, department.name as department, countries.name as country FROM (users, departments) LEFT JOIN countries on users.country = countries.uid

I simply added parenthesis around the table names. All fixed.