SQL join two similar tables

Question

I have two similar tables:

SELECT * FROM CTP0002;

SDKEY      SDNAME
2          Hello
4          World


SELECT * FROM CTP0003;

SSKEY      SSNAME
3          Name1
6          Name2

And i want this result:

SDKEY      SDNAME
2          Hello
4          World
3          Name1
6          Name2

I tried to join it, but that doesn't work.

use union [click here](https://msdn.microsoft.com/en-in/library/ms180026.aspx) — JanLeeYu, Feb 23 '16 at 07:32

score 4 · Accepted Answer · answered Feb 23 '16 at 07:30

4

Try this

SELECT * FROM CTP0002;
union all
SELECT * FROM CTP0003;

answered Feb 23 '16 at 07:30

SimarjeetSingh Panghlia

2,200
13
14

SQL join two similar tables

1 Answers1