I'm currently trying to get a recursive search for all the components and their fields on a master bill of material down to its lowest components. So far I've been able to build a CTE and most of the query works, the hang up is rejoining the CTE to itself. Anyone have any insight? (I've tried this both with the inner join for the explodedBom CTE and with an implicit inner join via the where clause)