Re: How to select without using sub-select?

[Hans-Peter Grimm]

[EMAIL PROTECTED] schrieb:
I am running MySQL 4.0.10 gamma.
I have records with data:
id title  version
1    a         1
2    a         2
3    b         1
4    b         2
How do I select all the records with highest version for each title?
[...]
Try:
SELECT t1.id, t1.title, t1.version
  FROM table_name t1 LEFT JOIN table_name t2
    ON t1.title=t2.title AND t1.version<t2.version
 WHERE t2.version IS NULL;
[optional: ORDER BY title]
Replace both occurrences of "table_name" with the name of your table. 
HTH, Hans-Peter









--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/[EMAIL PROTECTED]