SQLzoo.net

make union between different tables to build one single view or request?

Postgres
List a number of SELECT statements separated by the UNION key word. Be sure that you have the same number of columns in each of the SELECT statements.
SELECT name FROM customer
UNION
SELECT name FROM  employee
UNION 
SELECT name FROM artist


Specific to Postgres
none

Related links:

  • SELECT