M
Mike
Hi All,
I have four tables, Table1, Table2, Table3, and Table4.
I'm trying to create a query that will retrieve all the
data from all four tables, regardless of the tables that
have data or not, I need to have some results. I created a
query that leads me into getting the results from Table1,
Table2, and Table3 but not Table4. Table1 has foreign key
linked to the primary key in Table2 and also another
foreign key linked to the primary key in Table3. In
Table2, I have a foreign key linked to a field in the
Table4. In Table3, I also have another foreign key linked
to the field inTable4. This is the error message that pop-
up, when I created a query:
"The SQL statement could not be executed because it
contains ambiguous outer joins. To force one of the joins
to be performed first, create a separate query that
performs the first join and then include that query in
your sql statement".
I have four tables, Table1, Table2, Table3, and Table4.
I'm trying to create a query that will retrieve all the
data from all four tables, regardless of the tables that
have data or not, I need to have some results. I created a
query that leads me into getting the results from Table1,
Table2, and Table3 but not Table4. Table1 has foreign key
linked to the primary key in Table2 and also another
foreign key linked to the primary key in Table3. In
Table2, I have a foreign key linked to a field in the
Table4. In Table3, I also have another foreign key linked
to the field inTable4. This is the error message that pop-
up, when I created a query:
"The SQL statement could not be executed because it
contains ambiguous outer joins. To force one of the joins
to be performed first, create a separate query that
performs the first join and then include that query in
your sql statement".