You’ll use those parent/child fields in your union all join. There’s another common example with menu hierarchy that does something similar, might be a better example:
cte_testing.baq (39.7 KB)
You’ll use those parent/child fields in your union all join. There’s another common example with menu hierarchy that does something similar, might be a better example:
cte_testing.baq (39.7 KB)