A good recap for me. Thanks. Haven't used CTE in 3yrs. I used to use this to find parent child relationship between tables in Db2 z/OS