Link to home
Start Free TrialLog in
Avatar of bryan_z
bryan_zFlag for Canada

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.
ASKER CERTIFIED SOLUTION
Avatar of pssandhu
pssandhu
Flag of Canada image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial