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]
