Things to Remember about Joining Tables

When you join tables:

You are combining rows of data from two or more tables to form one result table
The join is based on common columns
If a column name in the SELECT statement has the same name in two or more tables, it must be prefixed to specify the table
The FROM clause contains the names of all the tables you are joining
You should use a WHERE clause to limit the result table