LEFT JOIN breaks and we don't like that
Posted: Tue Feb 17, 2009 12:19 am
Ladies & Gents,
my MySQL-knowledge is somewhat out-of-date, but LEFT JOIN has been part of my knowledge. For some reason, however, the following won't work anymore (SQL-statement simplified, but breaks all just the same)
Error is: "#1054 - Unknown column 'walks.id' in 'on clause' "
MySQL version is 5.1.30
Strange thing is, the statement worked until recently the only possible thing that could have changed (and I haven't followed up, yet) is that the hosting company may have updated to MySQL 5.1.30
Any help is appreciated
my MySQL-knowledge is somewhat out-of-date, but LEFT JOIN has been part of my knowledge. For some reason, however, the following won't work anymore (SQL-statement simplified, but breaks all just the same)
Code: Select all
SELECT walks.id, walks.station, walks.station_address, walks.type, walks.county, walks.description, walks.walk_name, walks.duration, walks.national_park, walks.station_address_type, walks.url_title, walks.country, walks.os_map FROM walks, waypoints LEFT JOIN rating ON walks.id = rating.walk_id WHERE walks.id = waypoints.walk GROUP BY rating.walk_idMySQL version is 5.1.30
Strange thing is, the statement worked until recently the only possible thing that could have changed (and I haven't followed up, yet) is that the hosting company may have updated to MySQL 5.1.30
Any help is appreciated