[cvele]

Nisam testirao, ali vako nesto je ono sto trazis:

select * from product p, versions v,
(select max(ver_id) as mid, ver_prod_id
from versions
group by ver_prod_id) maxresults
where v.ver_id = maxresults.mid
and p.prod_id=v.ver_prod_id
and p.prod_active = 1
and v.ver_active = 1

edit:
ovime se oslanjas na primarni kljuc tabele, jer sta ces ako budes imao istu dve verzije za isti datum ?