Barney, This explanation did it for me! Thanks a ton! What I needed to do was add a MAX() and MIN() to the SELECT.After all, I'm just hunting for the lowest and highest price to display. Then GROUP BY everything but those. My mistake was trying to GROUP BY just one thing, or GROUP BY *EVERY*thing.
Works like a champ! Thanks much, Will ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:226362 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=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
