SQL Server 2019

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.

CREATE TABLE table1
    ([id] int, [place] varchar(3), [Condition_2018] varchar(12))
;
    
INSERT INTO table1
    ([id], [place], [Condition_2018])
VALUES
    (123, 'ABC', 'flu'),
    (456, 'ABC', 'heart attack')
;
2 rows affected

CREATE TABLE table2
    ([id] int, [place] varchar(3), [Condition_2019] varchar(4))
;
    
INSERT INTO table2
    ([id], [place], [Condition_2019])
VALUES
    (123, 'ABC', 'flu'),
    (789, 'def', 'copd')
;
2 rows affected

CREATE TABLE table3
    ([id] int, [place] varchar(3), [Condition_2020] varchar(12))
;
    
INSERT INTO table3
    ([id], [place], [Condition_2020])
VALUES
    (456, 'ABC', 'heart attack'),
    (789, 'def', 'copd'),
    (123, 'ABC', 'flu')
;
3 rows affected

select 
  coalesce(t1.id, t2.id) id,
  coalesce(t1.place, t2.place) place,
  t1.Condition_2018,
  t2.Condition_2019,
  t3.Condition_2020
from table1 t1 full outer join table2 t2
on t2.id = t1.id
left join table3 t3
on t3.id = coalesce(t1.id, t2.id)


id
place
Condition_2018
Condition_2019
Condition_2020


123
ABC
flu
flu
flu

456
ABC
heart attack
null
heart attack

789
def
null
copd
copd

id	place	Condition_2018	Condition_2019	Condition_2020
123	ABC	flu	flu	flu
456	ABC	heart attack	null	heart attack
789	def	null	copd	copd