Post by alber99 » Thu Oct 08, 2015 10:47 am

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?

New member

Posts

Joined
Sun Apr 08, 2012 9:14 am
Who is online

Users browsing this forum: No registered users and 18 guests