In MySQL, I have 3 manager user id and the 10 reporting id. I need one manager data that means name and with his reporting id's names.. can anybody help me
For further actions, you may consider blocking this person and/or reporting abuse
Read next
Getting Started with Python: Why and How to Learn This Amazing Language
Dohal Islam -
Building SaaS Faster with Ercas for SaaS: A Template for Indie Hackers
Edun Rilwan -
AISuite: Simplifying GenAI integration across multiple LLM providers
Vishnu Sivan -
My Python Language Solution to Task 1 from The Weekly Challenge 299
Robert McIntosh -
Top comments (4)
PHP should help you out
MySQL r python only I needed
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.