[miks]

Ovo bi trebalo da radi.

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
;