Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
Moussie
Starting Member
20 Posts |
 Posted - 2001-08-19 : 09:58:18
|
| Hello!I had to work with a database that stores some of its records as follows:CLUB_ID VERSION DATA1 DATA2 ... DATAnAs you see, every line has a version number.Now, I want to get to only the last versionof every Club. Last version meaning the highest number, and it is different between each club. Some clubs have many versions,some only one (Version=1).Is that possible with pure Access SQL ?(Right now I am cycling through the datawith a recordset sorted on CLUB_ID, thenVERSION, and skipping the old versions...it has to be a better solution to this.Thank you!Erik |
|
|
|
|
|
Omitting old versions of a record