SELECT d.id, d.fname, d.date_field, dat.*
FROM mydates d
JOIN mydata dat
    ON (dat.date_field >= (d.date_field - interval 2 years)
    AND dat.date_field < d.date_field)
ORDER BY 3, 1;