Loading lesson path

Learn/SQL/SQL References

SQL•SQL References

SQL UNION Keyword

Concept visual

SQL UNION Keyword

Pointer walk

two pointers

left=0

right=6

1

3

Start at both ends

UNION Keyword

Union

The UNION

command combines the result set of two or more SELECT statements (only distinct values)

The following SQL statement returns the cities

(only distinct values) from both the "Customers" and the "Suppliers" table:

Example

SELECT City FROM Customers

Union

SELECT City FROM Suppliers

ORDER BY City;

SQL UNION Keyword

Concept visual

SQL UNION Keyword

Pointer walk

two pointers

left=0

right=6

1

3

Start at both ends

UNION Keyword

Union

The UNION

command combines the result set of two or more SELECT statements (only distinct values)

The following SQL statement returns the cities

(only distinct values) from both the "Customers" and the "Suppliers" table:

Example

SELECT City FROM Customers

Union

SELECT City FROM Suppliers

ORDER BY City;

SQL UNION Keyword

SQL UNION Keyword

UNION Keyword

Previous

Next

Union

The UNION

The following SQL statement returns the cities

Example

SELECT City FROM Customers

Union

SELECT City FROM Suppliers

Previous

Next

SQL UNION Keyword

SQL UNION Keyword

UNION Keyword

Previous

Next

Union

The UNION

The following SQL statement returns the cities

Example

SELECT City FROM Customers

Union

SELECT City FROM Suppliers

Previous

Next