this is exactly what I needed. Thank you :) > > If what you're asking is what I think, then the answer is very simple: > > (same CTE as you already have) > > SELECT * FROM fs_tree fs > JOIN employee e on fs.dept_id = e.dept_id > > Of course, you could also put this in the CTE itself (then you might > have to do it both before and after UNION ALL), but you haven't > mentioned any "employee recursion" (e.g. list all employees whose > leaders or their leaders belong to the department, regardless of > whether the employee or his closest leader belong to the department), > so there isn't much reason to complicate things. > > HTH, > Set > >
[Non-text portions of this message have been removed]
