| Subject | Merge results of recursive CTE with results of non-recursive CTE |
|---|---|
| Author | Nols Smit |
| Post date | 2011-08-31T13:10:28Z |
Hi,
Is it possible to merge results of a recursive CTE with the results of a non-recursive CTE?
I seems one can not have one executable block of SQL containing both.
Typically I use a non-recursive CTE to filter data for the main table, referencing many lookup tables. However, two of the lookup tables are tree-structures. If I filter data using only one tree-structure (as a lookup table) then a recursive CTE is easy to use but I can not figure out how to use a combination in one executeable block of SQL.
Regards,
Nols Smit
[Non-text portions of this message have been removed]
Is it possible to merge results of a recursive CTE with the results of a non-recursive CTE?
I seems one can not have one executable block of SQL containing both.
Typically I use a non-recursive CTE to filter data for the main table, referencing many lookup tables. However, two of the lookup tables are tree-structures. If I filter data using only one tree-structure (as a lookup table) then a recursive CTE is easy to use but I can not figure out how to use a combination in one executeable block of SQL.
Regards,
Nols Smit
[Non-text portions of this message have been removed]