MySQL Forums
Forum List  »  General

Select join in the same collumn
Posted by: Alexandre Salomé
Date: January 30, 2021 11:44AM


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 :


boss | employee
John Doe | employee1, employee2

I tried search a lot in web but I cant find if exist

Thank you

Options: ReplyQuote

Written By
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.