Recursive query

  • Thread starter Thread starter jshangkuan
  • Start date Start date
J

jshangkuan

I have a table that lists parent/child relationship for a certain item
in an MS Access table.

For example:
Employees
employee boss salary
A 'null' 10
B A 9
C B 9
D A 9

How would I use SQL in Access to generate a list starting at a
specified employee and the direct people working for that boss.

Your help would be greatly appreciated.
 
Back
Top