### Introduction

The Displaying Data from Multiple Tables using Joins module provides you with the instructions and devices to develop your hands on skills in the following topics.

• Using EQUIJOINS and NON EQUIJOINS to Access Data from Multiple Tables
• Using SELF JOIN
• Using OUTER JOIN
• Generate Cartesian Product using CROSS JOIN

### Exercise 1 - Using EQUIJOINS and NON EQUIJOINS to Access Data from Multiple Tables

In this exercise, you will learn the following about displaying data from multiple tables using JOINS:

• Establishing a connection to the database
• Example of SELECT statement using three tables
• Understanding the EQUIJOIN
• Understanding the NON EQUIJOIN
• Understanding the SELF JOIN
• Understanding the INNER JOIN
• Understanding the FULL OUTER JOIN
• Understanding the LEFT OUTER JOIN
• Understanding the RIGHT OUTER JOIN
• Understanding the CROSS JOIN
• Understanding the NATURAL JOIN

### Exercise 2 - Using SELF JOIN

In this exercise you will learn the following about displaying data from multiple tables using JOINS:

• Usefulness of Joining a Table back to itself

### Exercise 3 - Using OUTER JOIN

In this exercise you will learn the following about displaying data from multiple tables using JOINS:

• Using LEFT OUTER JOIN
• Using RIGHT OUTER JOIN
• Using FULL OUTER JOIN

### Exercise 4 - Generate Cartesian Product using CROSS JOIN

In this exercise you will learn the following about displaying data from multiple tables using JOINS: