Combining Tables

A query result can include data from multiple tables.  To combine data from tables, you use the JOIN operation from SQL.  The JOIN operation matches rows of one table with rows of another table, based on values in those rows.  For example, you can join the table titles with the table publishers.  Each row in the result set will describe a title, including information about that title's publisher, as shown in the following illustration: 

When you use JOIN, you have several decisions to make. The following topics describe the types of joins and how to use them:

• Types of Joins
  
• JOIN Columns
  
  
• JOIN Comparison Operators
  
  
• JOIN Tables