Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- with category_cte
- as
- (
- SELECT * FROM [PhoneConstructor.Host.DataEntities.Categorys] AS BaseCategory
- WHERE BaseCategory.ParentId IS NULL
- UNION ALL
- SELECT SubCategory.*
- FROM [PhoneConstructor.Host.DataEntities.Categorys] AS SubCategory
- JOIN category_cte
- ON SubCategory.ParentId = category_cte.Id
- )
- SELECT * FROM category_cte
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement