I am trying to write a sql query in the smart search filter to show the available variants of that category page can you suggest how to write it,I tried this waySELECT 'SKUID',s.SKUID,c.CategoryDisplayName FROM COM_OptionCategory c INNER JOIN COM_SKUOptionCategory s ON c.CategoryID=s.CategoryID GROUP BY s.SKUID,c.CategoryDisplayName but it will not search all the products.
SELECT 'SKUID',s.SKUID,c.CategoryDisplayName FROM COM_OptionCategory c INNER JOIN COM_SKUOptionCategory s ON c.CategoryID=s.CategoryID GROUP BY s.SKUID,c.CategoryDisplayName
Your first column must have a name
SELECT 'SKUID' as [SKUID], s.SKUID,c.CategoryDisplayName FROM COM_OptionCategory c
Follow the example in the documentation and you will be ok.
Please, sign in to be able to submit a new answer.