Anyhow, to answer your question, I was hoping to get one row per distinct doc_num whose version was the max() of all versions for that doc_num, and whose title corresponded to the record with the max version:

 title | doc_num | version
-------+---------+--------
  foo  |  1234   |   2
  baz  |  5678   |   1
[download]

Anyhow, my apologies for tempting fate in this manner. If I've overstepped my bounds by replying to your post, I once again apologize. But if you find the breath to chastize me once more, I also welcome links to any Database-related forums. ;)

Ahh. Then again, with a real database with subselects, that'd be:

SELECT title, doc_num, version
FROM atable
WHERE  (doc_num,  version) IN (
  SELECT doc_num, MAX(version) FROM atable GROUP BY doc_num
);
[download]

Again, this won't work in puny MySQL. PostgreSQL or better, baby!

-- Randal L. Schwartz, Perl hacker

If Kozz cannot upgrade to PostgreSQL for some reason couldn't Kozz ape a subselect with by creating a tempory table "ttable" and then join "atable" with that? sonething like this ...

create table ttable as  
   SELECT doc_num, MAX(version) FROM atable GROUP BY doc_num;

SELECT title, doc_num, version
  FROM atable a, ttable t
  WHERE  a.doc_num = t.doc_num and a.version = t.version;
[download]


... I don't know about the other monks I find SQL
fun like its a weird puzzle.