note
shadox
If i understand you well ( i am half asleep ), what you want is a list of titles with the greatest version.<BR>
Something like this<BR>
<CODE>
+-------+---------+---------+
| title | doc_num | version |
+-------+---------+---------+
| bar | 1234 | 9 |
| foo | 1234 | 7 |
| other | 2121 | 7 |
+-------+---------+---------+
</CODE>
Well if it is right, all what you need is to change your ORDER BY, for a GROUP by.<BR>
<CODE>
SELECT title, doc_num, MAX(version) AS version from test GROUP BY title;
# For this example "test" is the table name
</CODE>
<BR>
<HR WIDTH=50%>
<CENTER><I><FONT SIZE=-1 COLOR=NAVY>
Failure is not an option - it is a privilege reserved for<BR>
those who do not try hard enough.<BR>
</FONT></I></CENTER>
<HR WIDTH=50%>
155114
155114