Select join in the same collumn
Hello!
I have 2 tables as exemple:
- "table A" with name and age
- "table b" with name_boss and employee
- I have (table A) name='John Doe' that is (table A) name_boss='John Doe' boss of
'employee1' and 'employee2'
Is there a select command to return 'employee1' and 'employee2' in the
same collumn :
exemple:
boss | employee
John Doe | employee1, employee2
I tried search a lot in web but I cant find if exist
Thank you
Subject
Written By
Posted
Select join in the same collumn
January 30, 2021 11:44AM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.