SELECT
    m.id AS master_id,
    d.parent AS parent_id,
    d.version AS delta_version
FROM main AS m
LEFT JOIN delta AS d ON
    d.parent=m.id
WHERE
    delta_version = MAX(delta_version)
;