Merging multiple columns in oracle tables

Asked By 0 points N/A Posted on -
qa-featured

I am looking for your kind help in joining multiple columns from different tables into one table.

Table 1:
Ref ColumnA ColumnB
1   C    D
 
Table 2:
Ref ColumnC ColumnD ColumnE
1   M1   N1   P1
1   M2   N2   P2
 
Table 3:
Ref ColumnF ColumnG 
1   K    L   

I am anticipating following result

Ref ColumnA ColumnB ColumnC ColumnD ColumnE ColumnF ColumnG
1   C    D    M1   N1   P1   K    L
1             M2   N2   P2

Thank you very much. Please share the code snippet if possible to merge multiple columns into single result

 

SHARE

Login/Register to Answer

Related Questions