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.
For further actions, you may consider blocking this person and/or reporting abuse
We're a place where coders share, stay up-to-date and grow their careers.
What language are you outputting with?
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.