Requirement of Outer Join as Default

Ayat

Registered User.
Local time
Today, 14:03
Joined
Oct 27, 2005
Messages
33
Hello All,

Beginner level question!

I am working on a schema that might need outer joins for some of the queries and thereby reports I will need to produce. So, I wanted to get an idea from the pros about the following strategy:

How about leaving all the joins in the Relationships to begin with as Inner Join and change them to Outer Join as required (for a given Query. I believe this is possible)? What are the pros and cons of this approach.

Thank you
 
I generally leave all joins defined in the relationships window to default to Inner. If you have a situation where you know that most of the time you will want the join to be an outer join, you can specify that in the relationships window. Access will then create that type of join when it "auto-joins" tables as you add them to a query.
 
thanks for the reply. So I suppose you temporarily change the default inner joins to outer joins as required in a particular query. right?
 
temporarily change the default inner joins to outer joins
The join type used by one query has no impact on the join type used by any other query. The join type specified in the relationships window is only a suggestion. Its only purpose is to tell Access that when Access "automatically" adds a join line to a query because you have added two tables for which relationships are defined, that it should "assume" the suggested join type.
 

Users who are viewing this thread

Back
Top Bottom