Need help w/ SQL query in phpMyAdmin

[audradh]

Hmmm, can anyone tell me what is wrong w/ this:

SELECT products_description.products_name, products_description.products_description, products_description.products_id, products.products_image, products.products_price_sorter
FROM products_description, products
WHERE products.products_status = "1"

This gives me the same name, description and id attached to each different image, price_sorter, then the next name, description and id attached to each different image, price_sorter, then the next, etc.

Thanks for any help! I'm off to bed for now.
Audra