>>I need to select 3 fields from 1 table, but the 3rd field is a max(actiondate). First field is a non-unique ID (many records per ID), the second field is ActionType. I need the record that has the most recent ActionDate for each ID, including the ActionType field. For the life of me, I can not figure out how do this in a SQL statement. There is probably a subquery involved, but I can't figure out how to code it. Anyone got a solution? Something that starts with:
>>Select ID, ActionType, Max(ActionDate) as "ActDate" ;
>> from Transacts ....
>>TIA.
>
>Select * From Transacts Into Cursor tmp NOFILTER Order by ID,ActionDate
>Select * From tmp Group by ID
Thanks, Ed. I am contemplating about making the first statement into a local view, then querying with the 2nd when needed.
Mark McCasland
Midlothian, TX USA