Skip to Main Content

How to display the title of a group

User_5F8TPJun 12 2018 — edited Jun 12 2018

I have the following records in a table.

Create table xyz

(fruits    varchar2(50))

xyz

Apples                                   10

Oranges                                 11

Bananas                                   8

Vege

Group(peas, squash, potato)     20

Vege is the heading of the Group(peas, squash, potato).  I'm linking this table with another table that has everything except for Vege. I'm obtaining the following output.

Apples                                 

Oranges                              

Bananas                                

Group(peas, squash, potato)   

Whereas, I want to see the output as below;

Apples                                 

Oranges                              

Bananas    

Vege                          

Group(peas, squash, potato)   

Thanks!

Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked due to inactivity on Jul 10 2018
Added on Jun 12 2018
2 comments
65 views