Código SQL [-]LEFT JOIN INVENTARIO I ON P.ID_PROD = (SELECT M.ID_PROD FROM INVENTARIO M WHERE M.ID_PROD = P.ID_PROD ORDER BY FECHA DESC ) GROUP BY P.ID_PROD
LEFT JOIN INVENTARIO I ON P.ID_PROD = (SELECT M.ID_PROD FROM INVENTARIO M WHERE M.ID_PROD = P.ID_PROD ORDER BY FECHA DESC ) GROUP BY P.ID_PROD