Weeel . . for just the one-level-below you need to intruduce org_unit into the join with
where e1.ou = org_unit.ou_pk
and e2.ou = org_unit.parent_ou_pk
then put the selects for the two "levels" together with a UNION.
Printable View
Weeel . . for just the one-level-below you need to intruduce org_unit into the join with
where e1.ou = org_unit.ou_pk
and e2.ou = org_unit.parent_ou_pk
then put the selects for the two "levels" together with a UNION.