With one SQL query, I would like to return all subordinate
departments for
any given department. The use of multiple subqueries can do this if
the
number of levels is constant. I would like to know if there one
SQL
statement which will work without knowing the number of levels.

With one SQL query, I would like to return all subordinate
departments for
any given department. The use of multiple subqueries can do this if
the
number of levels is constant. I would like to know if there one
SQL
statement which will work without knowing the number of levels.