Problema query con JOIN

[MM88]

Ciao, ho due tabelle ( products e products_description ) che hanno in comune solo il campo products_id


Dalla tab products_description vorrei estrarre i campi:

- products_id
- products_name
- products_description


Dalla tab products vorrei estrarre i campi:

- products_image
- products_price
- products_date_available
- products_status



Ho eseguito questa query:

SELECT a1.products_id, a1.products_name, a1.products_description, a2.products_image, a2.products_price, a2.products_date_available, a2.products_status
		FROM products_description AS a1
		LEFT JOIN products_image, products_price, products_date_available, products_status AS a2 ON a1.products_id = a2.products_id
		WHERE products_status = 1
		GROUP by products_name
		ORDER BY products_name ASC

e non mi restituisce nulla, né mi segnala errori.


Come va corretta?


grazie.