http://qs321.pair.com?node_id=155143


in reply to MySQL question

You could try this ...
1 select D.title, D.doc_num, D.version from junk D, 2 ( 3 SELECT 4 A.doc_num doc_num 5 , MAX(A.version) version 6 from 7 junk A 8 , junk B 9 where 10 A.doc_num = B.doc_num 11 and A.title = B.title 12 and A.version >= B.version 13 group by 14 A.doc_num 15 ) C 16* where D.doc_num = C.doc_num and D.version = C.version
... bleh what a ugly mess.