Dealing with missing Data

[Sharad02]

Table A                                        

Date	Material	PSCS_ID	Site_ID	Spend	Volume
01-Jan-20	2	101	1001	78	6
05-Jan-20	3	104	1003	78	7
01-Feb-20	4	104	1005	79	9
01-Feb-20	4	103	1005	78	8
05-Feb-20	1	102	1004	81	7

Table B

Material	Material Name
1	Diesel_1LT
2	Diesel_10LT
3	Diesel_5LT

Table C

Site_ID	GRU	Country	Region	Currency
1001	IND	India	Asia-Pacific	INR
1002	USA	AMERICA	North America	USD
1004	SWZ	Switzarland	Central Europe	CHf

Table D

Cluster	Category	PSCS_ID	PSCD_Name
Energy	Fuel	101	Diesel
Energy	Fuel	102	Petrol
Energy	Fuel	104	Gasoline

How to  Merge All tables in Single table  without Data loss? like here is missing  material ID= 4 , Site Id= 1003,PSCS_ID =103

[Or · Accepted solution]

Load * From TableA;

LEFT JOIN

Load * From TableB;

LEFT JOIN

Load * From TableC;

LEFT JOIN

Load * From TableD;

As I understand it, a simple LEFT JOIN is what you need here.