Hi all,
I could use some help with a select statement.
Imagine a table like this:
personID, TransNum, TransDate, TransTime and other stuff
This table may contain many entries for any personId, but only the
one with the most recent TransDate/TransTime is valid. The data
actually comes from a foreign DB and TransNum is the numerical
sequence within the data file.
I'd like a select statement that returns personID and TransNum for
the most recent date/time for each personID for use in a view.
At this point I have:
Sel personID, (max(datetime(TransDate,TransTime))) from
TableNm group by MemberID
I haven't found a way to return TransNum from the same record that
qualifies as (max(datetime....))
TIA,
Ben Petersen
