MySQL Forums
Forum List  »  General

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

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

Options: ReplyQuote


Subject
Written By
Posted
Select join in the same collumn
January 30, 2021 11:44AM


Sorry, only registered users may post in this forum.

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.