Hi,
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:

MySQL Syntax (Toggle Plain Text)

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"

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,
Audra

Thank you pty, what you have done is
certainly easier to follow. Running that query leads to the same result I experienced.

The sales_categories column is a text type column.

In this instance, the result will only lead to one entry w/ the data "48,76,129"

Each of those numbers corresponds to a p.master_categories_id

The results yield the products in p.master_categories_id 48 and then stops there.
I'm guessing the problem lies in the fact that this is a text field?

I apologize if my description is confusing. I do not have the SQL lingo, so I speak in laymens' terms.

Peace,
Audra