I prefer SELECT table.* FROM table WHERE rev = (SELECT MAX(rev) FROM table WHERE id=table.id) I hate joins. Subselects are so much clearer imo - and

I prefer SELECT table.* FROM table WHERE rev = (SELECT MAX(rev) FROM table WHERE id=table.id) I hate joins. Subselects are so much clearer imo - and you don't end up with extra fields.