Back to Community Threads
1
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
5/26/2022 at 3:14 PM
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
5/26/2022 at 5:17 PM
Thank you!
Back to Community Threads

Reply to Thread