Merging multiple columns in oracle tables
Asked By
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
Â
