Recursive Query

Hi,

I have a table with an Id that references itself recursively and need help building the query.

Here's the table structure:
employee_id PRIMARY_KEY
employee_name
supervisor_id

The supervisor_id refers to the employee_id depending on who is the employee
supervisor.

My resultset should look like:
employee_id - employee_name - SUPERVISOR_NAME (instead of Id)

Thanks,

-Ray Received on Tue Mar 18 2003 - 14:16:27 CST