Learn

Sometimes we just want to stack one dataset on top of the other. Well, the UNION operator allows us to do that.

Suppose we have two tables and they have the same columns.

table1:

pokemon type
Bulbasaur Grass
Charmander Fire
Squirtle Water

table2:

pokemon type
Snorlax Normal

If we combine these two with UNION:

SELECT *
FROM table1
UNION
SELECT *
FROM table2;

The result would be:

pokemon type
Bulbasaur Grass
Charmander Fire
Squirtle Water
Snorlax Normal

SQL has strict rules for appending data:

  • Tables must have the same number of columns.
  • The columns must have the same data types in the same order as the first table.

Instructions

1.

Let’s return to our newspaper and online subscriptions. We’d like to create one big table with both sets of data.

Use UNION to stack the newspaper table on top of the online table.

Take this course for free

Mini Info Outline Icon
By signing up for Codecademy, you agree to Codecademy's Terms of Service & Privacy Policy.

Or sign up using:

Already have an account?