Wiz dali towa shte swyrshi rabota. Tozi log e ot Oracle DB, no sym izpolzwal samo standard SQL.

lpetrov@DB92> create table a (id int, n1 int, n2 int);
Table created.

lpetrov@DB92> create table b (id int, n1 int, n2 int);
Table created.

lpetrov@DB92> insert into a values (1, 100, 101);
1 row created.

lpetrov@DB92> insert into a values (2, 200, 202);
1 row created.

lpetrov@DB92> insert into b values (10, 1000, 1001);
1 row created.

lpetrov@DB92> insert into b values (11, 1100, 1101);
1 row created.

lpetrov@DB92> commit;
Commit complete.

lpetrov@DB92> select * from a;
ID N1 N2
---------- ---------- ----------
1 100 101
2 200 202
2 rows selected.

lpetrov@DB92> select * from b;
ID N1 N2
---------- ---------- ----------
10 1000 1001
11 1100 1101
2 rows selected.

lpetrov@DB92> create table c (id int, na1 int, na2 int, nb1 int, nb2 int);
Table created.

lpetrov@DB92> insert into c
2 select id, n1, n2, null, null from a
3 union
4 select id, null, null, n1, n2 from b;
4 rows created.

lpetrov@DB92> select * from c;

ID NA1 NA2 NB1 NB2
---------- ---------- ---------- ---------- ----------
1 100 101
2 200 202
10 1000 1001
11 1100 1101
4 rows selected.