mysql - SQL - merge 2 columns into 1 from separated tables (not concat) -

baisicly want take 2 table 2 columns have same information , combine them 1 table has 1 column data other 2.

i explain example:

table 1  id             |      number         | 1              |      100            | 2              |      150            | 3              |      160            | 4              |      170            |  table 2  id             |      number         | 1              |      110            | 2              |      120            | 3              |      130            | 4              |      180            |   result (with sql query using select, can check result):  number 100 150 160 170 110 120 130 180 

select number table_1 union select number table_2 

or union instead of union all if want remove duplicated values