Merging multiple columns in oracle tables

Asked By Anthony M McFarland 0 points N/A Posted on - 05/29/2015

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

 

• Status: Open
• Question Views: 836
• Answer Count: 0
• Vote Up 0 Vote Down

• Answer Accepted: No
• Question Category: Query Syntax