Hi,
I want all products in combination with the category.
Is this query ok? Or do i miss something?
Thanks for the reply!
Kr Bas
SELECT
cscart_product_descriptions.product,
cscart_category_descriptions.category
FROM
cscart_product_descriptions
INNER JOIN cscart_products_categories ON cscart_product_descriptions.product_id = cscart_products_categories.product_id
INNER JOIN cscart_category_descriptions ON cscart_products_categories.category_id = cscart_category_descriptions.category_id