Query with multi-tables

[Mike]

Hi All,

I have four tables, user , information, favorite, and
location. I'm trying to create a query that will retrieve
all the datas from all four tables ,regardless of the
tables that have datas or not, I need to have some
results. I created a query that lead me into getting the
results from user, information, and favorite but not
information. The User table has foriegn key linked to the
primary key in the Information table and also another
foriegn key linked to the primary key in the Favorite
table. In the Information table I have a foriegn key
linked to a field in the location table. In the favorite
table I also have another foriegn key linked to the a
field in location table. This is the error that pop-up:

"The SQL statement could not be excuted because it
contains ambigious outer joins.To force one of the joinsto
be performed first, create a separate query that performs
the firstjoin and then include tht query in your sql
statement".

What I did worng in mysql statement that cause this error?
Any clue??

Thanks for the help...

Mike

 

[Steve Schapel]

Mike,

It would be difficult to give specific advice without knowing more
details of your tables, and the query as you have got to so far. But,
as the error message implies, sometimes if you are using Outer Joins,
you have to do your query in two steps... first make a query to bring
the data together from two of the tables, and then make a second query
to combine the other table with the first query.

- Steve Schapel, Microsoft Access MVP