Re: How to select without using sub-select?

Thanks everyone! Here is a working solution: (Normalizing the tables as O'K Web Design suggested is also a good design solution) Hans-Peter Grimm <[EMAIL PROTECTED]> [EMAIL PROTECTED] schrieb: > I am running MySQL 4.0.10 gamma. > I have records with data: > id title version > 1a 1

How to select without using sub-select?

Hi, I am running MySQL 4.0.10 gamma. I have records with data: id title version 1a 1 2a 2 3b 1 4b 2 How do I select all the records with highest version for each title? (The records with id 2 and 4) I've been thinking about combinating GROUP BY and