Tree Walk statements

[Quoted] [Quoted] I'm having trouble with a tree walk statement and if anyone could give me a hand I would appreciate it.

Here's the deal:

Table name: assignments
Field1: employee (pk)
Field2: manager (also an employee)
Top level managers have themselves as managers

I need a list (two columns) of each manager and ALL his subordinates E.g.
A manages B who manages C. I need a list that looks like: A B
A C
B C

Thanks

Justin Received on Fri Jan 08 1999 - 10:49:05 CET