Before we begin a discussion on the types of joins, let's go over what a join is and why you would use one. A join refers to when you connect two or more tables in a query. Joining tables in a query requires you to join them on a related column that is in each table you want to join together. There are a couple of different types of joins, including the following ones:
- Inner join: This type of join returns only matching records from each joined table.
- Outer join: This type of join has a few types of joins that can be used, including the following:
- Left outer join: This type of join includes all rows from the left table and any matching rows between the left and right tables.
- Right outer join: This type of join includes all rows from the right table and any matching rows between the right and left tables.
- Full outer join: This type of join includes all...