Union

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

schema:gisq

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 capital,name FROM world WHERE name='France'
UNION
SELECT '',winner FROM nobel WHERE subject = 'Literature' and yr=1921

SELECT Operations

Concatenate Columns

Like

Union

Apostrophe

Full text search

Column name

Equi Join

Column name with spaces

NULL