I'm unable to find an exact example on stackoverflow, so here is my problem. In MySQL 4.x it works fine, but 5.x seems not to like the following:

```
SELECT some stuff..    
FROM schools, member , applications
LEFT JOIN courses ON courses.id = applications.course_id 
LEFT JOIN staff ON staff.id=member.staff_id

```

This section throws up an error saying "Unknown column 'member.staff\_id' in 'on clause'". How do I change this so that 5.x won't complain?

EDIT: I did notice that when using 'ONE' LEFT JOIN, it did matter where the table name was placed in the FROM part, ie it has to be at the end. Not sure this has any relevance to the problem though. This is only an issue with 5.x