It is quite readable, but Jim was just using it to illustrate what you're doing with the subquery, which is the way you really should be doing it in this situation. It doesn't make sense to do 2 round-trips to the database when one will do.
On 1/29/07, daniel kessler <[EMAIL PROTECTED]> wrote: > All it does is say give me everything in the subquery - it seems to me. And > really, that's just making two sets of records into one set - which is a cool > idea and very readable. ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Upgrade to Adobe ColdFusion MX7 Experience Flex 2 & MX7 integration & create powerful cross-platform RIAs http:http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:267999 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
