I've managed to piece together an SQL query (not literate in the language), but it isn't giving quite the data I expected. Here is the code:
SELECT products_description.products_name, products_description.products_description, products_description.products_id, products.products_image, products.products_price_sorter FROM products_description INNER JOIN ( products, salemaker_sales ) ON ( products_description.products_id = products.products_id AND products.master_categories_id = salemaker_sales.sale_categories_selected ) WHERE products.products_status =1 AND salemaker_sales.sale_status = "1"
The trouble I am seeing is this:
salemaker_sales.sale_categories_selected contains multiple variables separated by a comma
This query is only returning the first variable. What am I missing?
Any help much appreciated,