Avatar of pnesu
pnesu
 asked on

Join Condition

I have got a problem. i.e. there is a table which contains employee and their managers details.
example:
TableA
EMPID           MangaerID
1                   5
2                   4
3                   1
4                   3
5                   no Manager
Now I need to get another table populated with this data in the following way.
TableB
EMPReporting          ManagerID    
1                                  5
2                                  4
2                                 3
2                                 1
2                                  5
3                                 1
3                                   5               and so on along with other column values.
I have to get the employeeID, his manager'IDs and his manager's manageID. Please suggest me the best way.
Microsoft SQL Server

Avatar of undefined
Last Comment
Guy Hengel [angelIII / a3]

8/22/2022 - Mon
ASKER CERTIFIED SOLUTION
Guy Hengel [angelIII / a3]

THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
See Pricing Options
Start Free Trial
GET A PERSONALIZED SOLUTION
Ask your own question & get feedback from real experts
Find out why thousands trust the EE community with their toughest problems.
Experts Exchange has (a) saved my job multiple times, (b) saved me hours, days, and even weeks of work, and often (c) makes me look like a superhero! This place is MAGIC!
Walt Forbes