Consulta a dos tablas

[quimfv]

Código MySQL:

SELECT sbc.* , H2.id
FROM
(SELECT F.*, max(H.fecha) UltimoHistorial
FROM datos_form F LEFT JOIN historial H
on F.id=H.id_form
GROUP BY F.id) sbc
LEFT JOIN historial H2
ON sbc.UltimoHistorial=H2.fecha
AND sbc.id=H2.id_form;
 

Ya...

Quim