Search⌘ K
AI Features
Home
Courses
Learn Intermediate SQL

Using JOIN to Retrieve Information from More than Two Tables

Explore how to retrieve information from multiple tables in SQL using JOIN clauses. Understand restructuring databases to include Employee, Product, and Sale tables, and practice creating queries that link these tables to generate comprehensive reports.

We'll cover the following...

Restructuring database

As of yet, we have been working with the following two tables:

  • SalesData

  • Product

Let’s revisit the structure of these tables.

MySQL
DESCRIBE SalesData;
SELECT " "; -- Adds space bewteen the results of the two tables
DESCRIBE Product;

Adding the Product table allowed us to store products separately, enabling us to have products stored in our database without necessarily ...