Discussing join types in Microsoft Access 2019

There are two basic types of join types in a relationship:

  • Inner joins: This is the default join type that isset automatically when a new relationship is created. They only includerows where the joined fields from both tables are equal.
  • Outer joins: All records from the left table andonly those records in the right table that have a matching value in theleft table (a one-to-many relationship, or many to one). There are twotypes in this category and it depends on the direction of the join as towhether they are left or right join types.

Leave a Comment