Hi

Can I, in 1 SELECT statement, achieve the following:

Table1 contains fields PK = Primary Key, FK = Foreign Key, Date = Date.

I need to obtain the records from the table that have the highest date entry, do I need to select the dates first and then include those results in a sub-query in a 2nd Select?

Any ideas?

Thanks
Kev