I don't think he can remove dateSigned from the group by statement, since you must have all non-aggregate or subquery columns in the group by statement.
I think he needs to look at his data in the fashion that the query is grouping it. It may be the case that the min() and max() are the same for the signer/petid that is being returned. Cheers, Kris > You are grouping by dateSigned which ensures that the min() and max() will be > the same (because you get a new record for each value of dateSigned). > > Remove dateSigned from your select statement and your group by statement and > see if your results make more sense. ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:257708 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
