Classes

Local Joins are done in the query design module and are only in effect when the query is run. The tables are selected for the query and the joins created within the query design. 

Key Terms:  inner join - left outer join - right outer join - self join

Inner join - a join is which records are selected from two tables only when the records have the same value in the common field that links the tables. 

Left outer join  is a join in which all records from the first table, or left table are selected and only those records from the second table that have matching common field values are selected.

Right outer join is a join in which access selects all records from the second, or right, table and only those records from the first table that have matching common field values.

Self join exist when a table is joined with itself. A self join can be either a inner or outer join.

Copyright © by Earl T. Wylie 2001, 2002,2003,2004,2005,2006,2007