Displaying Data from Multiple Tables using JOIN

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:

• CROSS JOIN using two tables