Ricardo, either form works fine in my test code. My understanding is that the single version (=) allows matches when fields or contents are different lengths. The double version (==) allows matches only when the lengths are identical as well. - Joe
On Monday, February 16, 2009 4:32 AM, Ricardo Aráoz wrote: > >Date: Mon, 16 Feb 2009 06:32:26 -0300 >From: Ricardo Aráoz >To: [email protected] >cc: >Subject: Re: Simplest form of SQL? > >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). > > [excessive quoting removed by server] _______________________________________________ Post Messages to: [email protected] 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/[email protected] ** 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.
