Re: Which of the two statements do you find is easier to understand?
From: Niall Litchfield <niall.litchfield_at_gmail.com>
Date: Fri, 6 May 2011 19:15:16 +0100
Message-ID: <BANLkTikfCwMrVAEfy6sHRBBo7dLRh37WVw_at_mail.gmail.com>
Not the monty hall problem please no!
Date: Fri, 6 May 2011 19:15:16 +0100
Message-ID: <BANLkTikfCwMrVAEfy6sHRBBo7dLRh37WVw_at_mail.gmail.com>
Not the monty hall problem please no!
On 6 May 2011 19:12, "Rich Jesse" <rjoralist2_at_society.servebeer.com> wrote:
Michael writes:
> Which of the two statements do you find is easier to understand?
>
> WHERE (txv.b...
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.
Your second one gave me a headache. Just sayin'...
Rich
-- http://www.freelists.org/webpage/oracle-l -- http://www.freelists.org/webpage/oracle-lReceived on Fri May 06 2011 - 13:15:16 CDT