• In a database, a join explains how to merge records from two or more tables. A join is conceptually comparable to a table relationship. In reality, joins are what relationships are to tables when it comes to queries.
• The two fundamental sorts of joins that we will be addressing in this chapter are as follows: The inner connection The exterior connection
• Both of these can be readily produced from the design view of a query.
• An inner join is the most common sort of join, and it is also the default join type in Microsoft Access. Only the rows or records where the connected fields from both tables are equal will be displayed in an Inner Join.
• An outer join shows all rows from one table and just those rows or records from the other table that have the same connected fields. In other words, an outer join displays all rows from one table and only the rows from the other table that correspond to them.

Read More: How Do You Import Data From Another Access Database?