I have an employee table. Primary key of userID. One of the columns is self referential, and gives the userID of a employee's supervisor.
I need a query that for a given userID, it lists all employees for that person, at all levels. So for example, all records would be returned for a CEO.