Clarification: I should have worded that as "Doesn't look like MS SQL Server 2005 will let me return more than one column from a sub-select in a where clause for comparison."
I really wish there was an aggregate which would let me select the value of a column from the same row which the max() function picked if that makes any sense. Of course the max value may have existed on more than one row, but I'd settle for a random selection. In that case, multiple products could have been added to the same order at the exact same time so just picking one of those records that had the max value would work. ~Brad -----Original Message----- From: Brad Wood [mailto:[EMAIL PROTECTED] Sent: Friday, September 28, 2007 11:46 AM To: CF-Talk Subject: RE: SQL Question Doesn't look like MS SQL Server 2005 will let me compare more than one column in a where clause. ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Get involved in the latest ColdFusion discussions, product development sharing, and articles on the Adobe Labs wiki. http://labs/adobe.com/wiki/index.php/ColdFusion_8 Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:289753 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
