evo jos jedna varijanta - sada za slucaj da nema verzije koja se ponavlja na vise datuma, dok jos nisam poceo da radim:
Kôd:
SELECT p.*, v.*
FROM (
SELECT v.ver_prod_id, MAX(v.ver_date) version_dt
FROM Versions v
INNER JOIN Products p ON v.ver_prod_id = p.prod_id
WHERE p.prod_cat = 1
AND p.prod_active = 1
AND v.ver_active = 1
GROUP BY v.ver_prod_id
) m
INNER JOIN Versions v ON v.ver_date = m.version_dt
INNER JOIN Products p ON p.prod_id = v.ver_prod_id