>From the transaction table, I need the the most recent (highest number)
transactionID, the paidThru field (which may not always be the latest date,
see example snip in previous message), and if you need the memberID (which
corresponds to the memberID in the membershipList table).
Thanks for your help with this.
Mark
_____
From: Marc Lowe [mailto:[EMAIL PROTECTED]
Sent: Wednesday, August 18, 2004 2:36 PM
To: CF-Talk
Subject: Need more info
I know why you are getting the results you are getting but I do not have
enough information regarding your data to provide a solution yet.
If you add t.paidthru in your group by clause then it will get multiple
entries (a cross-join), but if you leave it out you will get invalid group
by errors.
Questions that I have for you are:
What fields do you need from the transaction table?
Will the paidthru field always be the latest date?
_____
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
