How to SQL query all subcategories of a category?
Question asked by Art Crowley - 5/26/2022 at 1:25 PM
Answered
We have a category of 'End Mill' with several subcategories.  How do we create a query for all subcategories of 'End Mill' without listing each subcategory separately?

2 Replies

Reply to Thread
1
Mark Culos Replied
Employee Post Marked As Answer
Art,

Find in your query from prior to Atrex 20

Where Category = 'End Mill'

and substitute

Where Category Like 'End Mill\%'
0
Art Crowley Replied
Thank you!

Reply to Thread