combine 2 tables in search sql code example

Example 1: sql view where tables have same column name combine results

SELECT table1.Column1, table1.Column2
FROM table1

UNION

SELECT table2.Column1, table2.Column2
FROM table2

Example 2: sql combine results from two tables

SELECT *
  FROM tutorial.crunchbase_investments_part1

 UNION

 SELECT *
   FROM tutorial.crunchbase_investments_part2

Tags:

Sql Example

Related