Lynn, ***please***, I have not oversimplified the problem. The problem is to use CTEs. You are providing an alternate to CTEs, which I am not asking for unless someone can produce a result set that I am after (yours doesn't).

My original DDL is sufficient for demonstrating two sets of CTEs, each of which produce a result set, which I want to combine into one.