oracle - Combining two tables using MERGE -

i trying combine 2 tables vertically

table

id   salary                                50                               b       100 

table b

id   salary c        50 d       200 

i trying table looks like

id   salary        50                      b       100 c        50 d       200 

i using this:

merge table_a using (   select id, salary table b ) b on (a.id = b.id); 

this not working.

your merge syntax not correct. see below. read more merge here

merge table_a      using (select id, salary table b) b on a.id = b.id when not matched insert  (id,salary)  values (b.id,b.salary);