Hi,

I have an employee table wich contain information about an employee and also his/her manager's id. which refers to the employeeid field in same table.

I need a query which will give me all employees under a given employee, not only upto one level, but upto all available levels.

thanks,

you cannot do that with sql except in oracle (and maybe db2, i'm not sure)