DEV Community

loading...

Discussion on: MySQL

Collapse
adeleyeayodeji profile image
Adeleye Ayodeji

What language are you outputting with?

Collapse
sherbin29 profile image
Sherbin W Author

Thank you for your response. I need it in MySQL. let me describe the problem. we have 10 employee data in that 1 is manager 2,3,4,5 is an employee they will report to 1 and 6 is manager 7,8,9,10 is an employee they will report to 6. 1 and 6 don't have reporting id but they will have user id. so if am using a self join I am getting the 2,3,4,5 employee name but 1 is missing. that my problem.

Forem Open with the Forem app