Ambiguous Outer Joins

[DoDo1975]

I am getting the error message relating to Ambiguous outer joins when I try to run my query in access using the QBE pane. I know that I can get around this error by deleting the automatic join it makes between 2 tables that I dont want joined, but I would like to know why it is trying to join them.

I am using multiple (12 or so) tables that are all linked to the same primary table through the same primary key. I am using multiple tables for a couple reasons, mainly because there are over 200 fields and I wanted them split up into different subsets.

Can anyone tell me why I am getting these ambiguous join errors; and how to stop it. I have also created dynamic SQL queries by using input boxes and the queries work great that way, but when building in the QBE pane it immediately joins the tables up when I dont want them joined.

This will create problems when other people use the database.

Thanks in advance.

JL

 

[Francescina]

This complex SQL problem has a simple solution:
Use sub queries and embed them into your main query.