Hi Mark, Jim-- That was indeed the case. Just didn't see it.
Thanks very much! --Ben Gaulin, Mark wrote: >Apparently you can't use ORDER BY on the first SELECT, so I presume that >the second ORDER BY will be applied to the combined rows. >Thanks > Mark > > +-------------------------------------------+ + Ben Conner [EMAIL PROTECTED] + + Web World, Inc. 888-206-6486 + + PO Box 1122 480-704-2000 + + Queen Creek, AZ 85242 + +-------------------------------------------+ ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:297222 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
