>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.
Scott,
A cheezy solution is to add a blank item to each of the lookup tables. Then your inner joins (or WHERE clauses) will work.
Barbara