Re: Which of the two statements do you find is easier to understand?
Date: Fri, 6 May 2011 11:46:12 -0700
On Fri, May 6, 2011 at 11:08 AM, Rich Jesse < rjoralist2_at_society.servebeer.com> wrote:
> Michael writes:
> > Which of the two statements do you find is easier to understand?
> > WHERE (txv.business_unit2tcode NOT IN (41940)
> > OR (txv.business_unit2tcode IN (41940) AND txv.ext_source_key IS
> > NULL));
> I'll take what's behind Door #3:
> WHERE txv.business_unit2tcode != 41940 OR txv.ext_source_key IS NULL;
> Simple, to the point, and logically equivalent to your first WHERE clause.
One would hope this is SQL that is run infrequently...Received on Fri May 06 2011 - 13:46:12 CDT