Using OC 2.0.3, and in phpMyadmin, I'm trying to figure out the SQL statement to output a list of my products (names) with their category (names).
I'm a novice at SQL but tried and failed with:
SELECT `xdt_category_description`.`name`, `xdt_product_description`.`name`
FROM `xdt_product_to_category`,`xdt_category_description`, `xdt_product_description`
WHERE `xdt_product_to_category`.`category_id` = `xdt_category_description`.`category_id`
Can you help craft this statement?