Re: MySQL question

[rbc]

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.