bryan_z
asked on
SQL to retrieve the last receipt an individual was included in.
Hi,
I'm looking at trying to determine, for each member in the system, the last receipt they appeared on. The tables look as follows (in brief):
Receipts: Unqiue ID, Member ID, Receipt Date
Each member can appear multiple times in the table. What I want is, for each member, provide me the unique ID for the last receipt they appeared on based on receipt date.
THanks.
I'm looking at trying to determine, for each member in the system, the last receipt they appeared on. The tables look as follows (in brief):
Receipts: Unqiue ID, Member ID, Receipt Date
Each member can appear multiple times in the table. What I want is, for each member, provide me the unique ID for the last receipt they appeared on based on receipt date.
THanks.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.