Ovo bi trebalo da radi.
Kôd:
SELECT
p.prod_id,
p.prod_name,
v.ver_name,
v.ver_date
FROM
products p INNER JOIN versions v ON p.prod_id=v.ver_prod_id
INNER JOIN (
SELECT
ver_prod_id, MAX(ver_date) as ver_date
FROM
versions
GROUP BY ver_prod_id
) t ON v.ver_prod_id=t.ver_prod_id AND v.ver_date=t.ver_date
;