Selecting Data from More than One Table by Using Joins

　　Inner Joins: An Inner join returns only the subset of rows from the first table that matches rows from the second table You can specifies the columns that you want to be compared for matching values in a WHERE clause.

SQL Procedure User's Guide (Multiple Table)