join or merge two table based on id merge

Question

I have two tables:

I am looking for the results like mentioned in the last.

I tried union (only similar col can be merged), left join, right join i am getting repeated fields in Null areas what can be other options where i can get null without column repeating

Most people here want formatted text, not images (or links to images.) — jarlh, Jul 21 '17 at 07:59

score 0 · Answer 1 · answered Jul 21 '17 at 08:03

0

A full join would get all results from both tables.

select
A.ID,
A.ColA,
A.ColB,
B.ColC,
B.ColD
from TableA A
full join Table B on A.ID = B.ID

Here is a good post to understand joins

answered Jul 21 '17 at 08:03

dbajtr

1,984
2
14
20

score 0 · Answer 2 · answered Jul 21 '17 at 08:07

0

You can try distinct:

select distinct * from 
tableA a, 
tableB b 
where a.id = b.id;

It will not give any duplicate tuples.

answered Jul 21 '17 at 08:07

Pritam Banerjee

16,584
10
80
99

join or merge two table based on id merge

2 Answers2