MySQL, dotaz na nejvyssi verzi

[Kouba Tomas]

Mo dekuji, je to ono...

-- 
Tomas Kouba
mailto:tomas na neo.cz 

> 	select a.*
> 	from b_ad_verze a left outer join b_ad_verze b
> 	on a.id = b.id and a.verze < b.verze
> 	where b.verze is null
> 
> ------------------------------------------------------------------------
>  Honza Pazdziora | adelton na fi.muni.cz | http://www.fi.muni.cz/~adelton/
>    .project: Perl, DBI, Oracle, MySQL, auth. WWW servers, DBD::XBase.
> ------------------------------------------------------------------------