Skip to Main Content
Forums

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Combine columns from multiple tables

2942624Jul 9 2018 — edited Jul 9 2018

Hi,

I am trying to combine columns from multiple tables.

select a.name,b.name,c.name from tab1a,tab2 b,tab3 c.

I get output as

AC1  EN1  PL1

AC2   EN1  PL2

AC3   EN1  PL2

Instead, it should be

AC1  EN1  PL1

AC2           PL2

AC3         

Any suggestions on how to get above result.

Thanks in advance.
This post has been answered by mathguy on Jul 9 2018
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Aug 6 2018
Added on Jul 9 2018
8 comments
2,836 views