duda con un select...

[1pere3]

Me han ayudado con 2 selects, que los quiero enseñar. Ninguno funciona, pero entiendo que son más que correctos:


PRIMERO:

select LEFT(products_description.product_name,20) as product_name, FORMAT(products.products_price,2) as product_price, products.products_image as products_image from products, products_description WHERE products.products_model=products_description.produ cts_name order by products_id desc limit 0,6

SEGUNDO:

SELECT products.products_price, products.products_image, products_description.products_name FROM products INNER JOIN products_description on products.products_id = products_description.produtcs_id order by products_id desc limit 0,6


Sigo en mi busqueda por el select que funcione...