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.