How to merge different columns into single table

whitestonek — Tue, 28 Aug 2018 16:17:00 GMT

I have 4 tables TABLEA, TABLEB, TABLEC, TABLED.

TABLE A TABLE B TABLE C TABLE D

S.NO SALES S.NO DATE S.NO PRODUCTS S.NO LOCATION

1 253 1 01/03/18 1 LENOVO 1 HYD

2 125 2 02/03/18 2 LG 2 USA

3 326 3 05/03/18 3 SONY 3 CHINA

4 555 4 09/04/18 4 TATA 4 JAPAN

5 125 5 10/04/18 5 BPL 5 UK

6 15/04/18 6 CASIO 6 ITALY

7 HP

I want OUTPUT like this below:

S.NO SALES DATE PRODUCTS LOCATION

1 253 01/03/18 LENOVO HYD

2 125 02/03/18 LG USA

3 326 05/03/18 SONY CHINA

4 555 09/04/18 TATA JAPAN

5 125 10/04/18 BPL UK

Re: How to merge different columns into single table

sunny_talwar — Tue, 28 Aug 2018 17:09:50 GMT

Left Join them all into a single table

Table:

LOAD S.NO,

SALES

FROM TABLE A;

Left Join (Table)

LOAD S.NO,

DATE

FROM TABLE B;

Left Join (Table)

LOAD S.NO,

PRODUCTS

FROM TABLE C;

Left Join (Table)

LOAD S.NO,

LOCATION

FROM TABLE D;