I have a main table (schedule) with several (6) look-up tables (location, category, contact, ...).

They are related by key fields (schedule.loc_id -- location.loc_id, etc.) The schedule table does not necessarily have these fields entered (the client wants them optional).

What is the syntax for several outer joins with SELECT? I took a shot at it with the query builder, but it doesn't retrieve the right data either.

Setting relations and running reports works, but I have to export this to Excel.

Any help or alternatives are greatly appreciated.