🚀 go-pugleaf

Hi

I am tryring to extract the most recent record from a table for a given ID
number.

i.e.

mainID        subID        Date_updated        Details......

20                 101        10/02/2002           ...........
20                 101        14/04/2002           ...........
20                 102        15/03/2002           ............
20                 102        15/06/2002            ................

I thought I could use grouping and MAX function

i.e.

SELECT max(date_updated) as MaxDate, subID, policyID
WHERE mainID = 20
GROUP BY subID

this returns

ID        subID        Date_created

20        101           14/04/2002
20        102           15/06/2002

this is good, however I need to return the other details in the table. By
selecting more fields to display it does not work as it wants to group them.
By putting this query into a sub query you are unable to do so as it returns
2 fields Date_created (for the max date thing) and Benefit ID which is what
i want to display the record by.

Any ideas anyone?

TIA Phil