[cfaussie] SQL Query

[Dale Fraser]

Hi   Have a table with the following field   subjectCode subjectHand subjectSex testedDate sessionName   I want to get a query which returns the three subject fields, 1 record per subject code returning the most recent record based on testedDate and the session that was selected in that date.   Any ideas? Regards Dale Fraser   --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "cfaussie" group. To post to this group, send email to cfaussie@googlegroups.com To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/cfaussie -~----------~----~----~----~------~----~------~--~---