Does anyone have an example of a query that contains multiple left joins? I can write this just fine in MS SQL or MySQL but can't get it to work in Access. Here is my example of what works in SQL but not Access:

select * from records
left outer join payments on payments.payerid =

left outer join attendee_course on attendee_course.attendeeid =
left outer join courses on attendee_course.courseid =

There is always a row in Records, may or may not be a row in Payments. There may or may not be a row in Attendee_Course, but if there is, there's always a corresponding row in Courses.

This always gives a syntax error in Access but I know it's standard SQL syntax. Any help is appreciated.