Help with recursive statement

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Can someone help with the following recursive statement:

I have an employeeID, supervisorID, supervisor_last_name and
supervisor_first_name
For each employeeID how to populate supervisor_last_name and
supervisor_first_name
The supervisorID is the employeeID and it contains last_name and first_name

Thanks in advance,
 
See if MVP Allen Browne's suggestions might not help.
Self Joins: http://allenbrowne.com/ser-06.html


Can someone help with the following recursive statement:

I have an employeeID, supervisorID, supervisor_last_name and
supervisor_first_name
For each employeeID how to populate supervisor_last_name and
supervisor_first_name
The supervisorID is the employeeID and it contains last_name and first_name

Thanks in advance,
Click to expand...

_______________________________________________
hth - RuralGuy (RG for short)
Please post to the NewsGroup so all may benefit.
 
Back
Top