RE: SQL Query problem

[Mark Leder]

I'll give this a try and let you know.  Thanks for your response.

  _____  

From: Marc Lowe [mailto:[EMAIL PROTECTED]
Sent: Wednesday, August 18, 2004 12:54 PM
To: CF-Talk
Subject: Re: SQL Query problem

I left a lot of your query out but you should be able to look at this and
see the biggest differences.

SELECT m.memberID, m.firstname, m.lastname,
       MAX(t.transactionID) as maxID
FROM members m
INNER JOIN trans t ON t.memberID = m.memberID
GROUP BY m.memberID, m.firstname, m.lastname

Hope that helps,
Marc
  _____

---

[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]

---