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 ?
Poslednja izmena od cvele : 13. 04. 2009. u 15:52.
|