Subject SQL-question, something like FOR or Aggregate?
Author John vd Waeter
Hi all,

Problem simplified:

I have a table BOOKS, 5 fields:
1. ID
2. Genre
3. Title
4. Author
5. DateOfSubmission

The table contains bookdata (obvious).
Now I would like to get an aggregate that, for everyGenre, shows me the
Titles and Authors of the Latest submitted book. If there are 5 Genres,
I should get a 5 row table.

In metacode: For every Genre, find the latest DateOfSubmission, and give
me ID, Author and Title.

It looks like a simple SQL, but I'm a bit stuck on the "for every Genre".

Can anyone give me a hint?