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!