Whoops. Try this one. Meant 'group by' but typed 'order by'. Sorry about that.
SELECT memberID, MAX(paidThru) AS paidThru FROM someTableName GROUP BY memberID cheers, barneyb On Thu, 17 Mar 2005 22:22:41 -0500, Mark Leder <[EMAIL PROTECTED]> wrote: > Tried it, here's the error: > > [Macromedia][SQLServer JDBC Driver][SQLServer]Column > 'someTableName.memberID' is invalid in the select list because it > is not contained in an aggregate function and there is no GROUP BY clause. > > Mark -- Barney Boisvert [EMAIL PROTECTED] 360.319.6145 http://www.barneyb.com/ Got Gmail? I have 50 invites. ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:199284 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
