Dealing with missing Data

Sharad02 — Wed, 10 Aug 2022 13:30:43 GMT

Table A

Table B

Table C

Table D

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

Re: Dealing with missing Data

Or — Wed, 10 Aug 2022 13:41:17 GMT

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.