# Displaying Data from Multiple Tables using JOIN

Practice Labs Module
Time
36 minutes
Difficulty
Intermediate

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.

Join over 3 million cybersecurity professionals advancing their career
Required fields are marked with an *
or

Overview

### 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: