Types of Joins

See Also   Tasks

When you join tables, the type of join that you create determines the rows that appear in the result set. You can create the following types of joins:

You can also create a self-join, which compares rows within the same table. For example, you can use a self-join to find all publishers that are in a specific city and have the same postal code. For details, see Creating Self-Joins.