Sentencia SQL con 2 tablas último valor agrupados

[Libras]

otra forma de hacerlo

Código SQL:

SELECT * FROM products AS t1
LEFT JOIN (SELECT MAX(id) AS id,stock, id_product FROM inventory WHERE id_zone=1) AS t2 ON (t1.id_product=t2.id_product)