I have a table that's something like this:<BR><BR><pre class="ip-ubbcode-code-pre">CREATE TABLE thread(id INT, parentid INT, sometext TEXT);</pre><BR><BR>The values ...
Problem: Starting from the HR department head (dept_id = 1, manager_id is NULL), list all employees in that reporting chain (head + all direct/indirect reports).
Some results have been hidden because they may be inaccessible to you
Show inaccessible results