Learn SQL/

...

/

Using JOIN to Retrieve Information from More than Two Tables

Using JOIN to Retrieve Information from More than Two Tables

Learn how to structure a database with multiple tables.

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.

Press + to interact
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 being linked to ...