> If I order by the sort fields, I get the first set of results, doing a > GROUP BY Item is the same. So I know I need to do a sub-query or > something else to get the desired result. Ideas?
Oops, sorry for the typos on the sample records. You get the idea hopefully. I should add that the sort values will not necessarily be different for every item although typically at least one record will be. So the first record for each is not necessarily going to be the one that determines the order, as in the example I gave. --- Mary Jo ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/sql/message.cfm/messageid:3266 Subscription: http://www.houseoffusion.com/groups/sql/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.6
