I have an issue to get concatenated text from below two tables(product_to_category & category_description)
I need mysql query to get output as "Electronics,Electronics Component Connectors,Electronics Accessories" from category_description table's name column.That query will compare category_id in these tables with where condition as product_id = 276.
I tried this query,but it returns empty result -
SELECT GROUP_CONCAT(description SEPARATOR ',')
FROM `ocrk_category_description`
WHERE `category_id` IN (SELECT GROUP_CONCAT(category_id SEPARATOR ',') as `category_id`
FROM `ocrk_product_to_category`
WHERE `product_id` = 276
)
Any ideas? i can provide you more information if need.