Bangs head on desk... Needs more coffee... Don't know why I tried to overcomplicate things, but that seems to work. Thanks!
CV -----Original Message----- From: Leigh [mailto:cfsearch...@yahoo.com] Sent: Wednesday, January 13, 2010 11:08 AM To: cf-talk Subject: Re: (ot) SQL Guru Needed What about a basic join? SELECT MIN(optPrice) AS minPrice, MAX(optPrice) AS MaxPrice FROM productOptions po INNER JOIN options o ON o.optID = po.optID WHERE productID = <cfqueryparam value="#pid#" cfsqltype="cf_sql_integer"> ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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/cf-talk/message.cfm/messageid:329624 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4