Re: Which of the two statements do you find is easier to understand?
- From: Niall Litchfield <niall.litchfield@xxxxxxxxx>
- To: rjoralist2@xxxxxxxxxxxxxxxxxxxxx, ORACLE-L <oracle-l@xxxxxxxxxxxxx>
- Date: Fri, 6 May 2011 19:15:16 +0100
Not the monty hall problem please no!
On 6 May 2011 19:12, "Rich Jesse" <rjoralist2@xxxxxxxxxxxxxxxxxxxxx> 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
--
//www.freelists.org/webpage/oracle-l
Other related posts:
