Recursive query

[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.

 

[Allen Browne]

This kind of thing is not simple in SQL.

Here's some links to get you started:
http://www.intelligententerprise.com/001020/celko.shtml
http://www.dbmsmag.com/9603d06.html
http://www.dbmsmag.com/9604d06.html
http://www.dbmsmag.com/9605d06.html
http://www.dbmsmag.com/9606d06.html

And a more generic one:
http://www.mvps.org/access/modules/mdl0027.htm