computer






 

Question by  Jes (17)

When to use an outer join over an inner join when doing Microsoft access query's?

I am trying to understand the difference between outer and inner join in access and when you use either one.

 
+7

Answer by  ebo (49)

An inner join will combine rows from two tables when the values in the joined fields match. An outer join on the other hand will include rows even if they do not have matching fields. An outer join is used when making a database where the information is different in each column.

 
+6

Answer by  gigo (1706)

Generally you can change your join type in the access's join properties dialog box. Inner join: lists only the keys. Outer join: lists the keys and all the other columns.

 
+6

Answer by  mb (5482)

You have to alter your search perameters. Go into the query tab. Under the Parameters function put in your main query, then tab over to "Join" and put in your secondary query then execute.

 
+3

Answer by  amitkinha (293)

An inner join gets data from both tables where the specified data exists in both tables while an outer join gets data from the source table at all times.

 
+3

Answer by  StarOne (941)

An inner join will combines rows from two tables when the values in the joined fields match. An outer join will include rows even if they do not have matching fields. An outer join is used when making a database where the information is different in each column.

 
You have 50 words left!