CTE递归实现级联查询

------商品类型级联多个子类型
 with GoodsTypeCol as
    (
        select * from TM_GoodsType where ParentCode = '1' and isEnable = 1
        union all
        select gt.* from TM_GoodsType as gt inner join GoodsTypeCol as gtc on gt.ParentCode =gtc.code
        where gtc.ParentCode = '1' and gtc.isEnable = 1
    )                            
 select Code from GoodsTypeCol