My table is like
So requiement is if I want to see what are employee_id are available under HR_id 999 then it should give
100 (Via HR_Id 200) 999
101 (Via HR_Id 200) 999
200 (Direct) 999
201 (Direct) 999
I dont have access to Teradata. I have one free oracle online server. So I tried with that for solutions, since I work on other Databases too. I dont know if I can have a Teradata online server.
How about the solution given above with recursive? If it does not work , then we can think of cross join and then join the result with the parent query.
Can anyone let me know if I have any free Teradata online server?
Thanks and regards,