Joe Yoder wrote: > Actually, the approach I used in the original example with an > intermediate cursor is probably simpler that any scheme that does it all > in one statement. I am simply trying to improve my understanding of SQL > queries. > Thanks - Joe > Joe, have you tried correcting the "==" vs "=" issue? The first example is clearer, and when the job at hand is complicated I tend to prefer it. But sometimes the second approach is better because once it knows what you want to do, the engine may better optimize the query (not always).
_______________________________________________ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/499932aa.4030...@gmail.com ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
