SQL: recursive select

hi!

i have a general question concerning self-referencing tables; let's assume a table of employees, where each employee's manager is stored in the same table and managers can themselve have managers;

is there a way to query all managers of person X with ONLY ONE SELECT-statement?

e.g.: X has manager Y, who could possibly have manager Z, who could...(unknown depth of recursion!)
=> managers of X are Y,Z,...;

/thanxs Received on Mon Dec 20 1999 - 10:27:50 CST