1. Needed to join two or more tables

2. Resolves the problem of joining table columns that have the same name

3. Where the joining is specified

4. Where an alias is identified

5. Used to append one table to another

a. The WHERE clause

b. Common columns

c. The UNION clause

d. The FROM clause

e. The SELECT clause

f. Aliases