Re: SQL Query problem

[Marc Lowe]

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]

---