I use this query in PHPmyAdmin, i have date that contain(date,hour),supp, price and code_product (it repeated many times) :
I want to return the last price for the last date of product code
SELECT invent.code_product,products.supp,products.price,products.date FROM products LEFT JOIN list_product ON products.supp = list_product.supp LEFT JOIN invent on list_product.id_product = invent.fk_product WHERE invent.code_product= "XXX185" ORDER BY products.date DESC LIMIT 1 ;
This is the result for one code :
The query works for one code and limit it the result in 1.
How can i use the same query to return the last date and price for all codes?