What are Inner and Outer Data Joins in Access 2007? An Inner or Outer Join is a query that displays all tables, where you can create a temporary link or "Join" between two tables. The Inner Join lets the query show related records from two tables, as long as both contain a Field with the same data type, and that one of those fields in one of the two tables is a Primary key. Where the Outer Join will display all records from one table and only matching records of the second table. And this can go either way, depending upon which table you want the Outer Join to have display all the records from and again only matching records from the second table.

Purchase the training video and you can see this in action for yourself!