List:General Discussion« Previous MessageNext Message »
From:hsv Date:February 3 2013 12:59am
Subject:Re: Complex MySQL Select Statement Help
View as plain text  
>>>> 2013/02/02 12:58 -0600, Peter Brawley >>>>
On 2013-02-01 10:18 PM, hsv@stripped wrote:
>>>>>2013/01/31 22:24 -0600, Peter Brawley >>>>
>Is this what you mean?
>
>Select,
>pricelist
>If( !IsNull(specialprice) And specialprice < unitprice And CurDate() Between
> startingDate And endingDate,
>specialprice,
>unitprice
>) as used_price
>>From catalog
>Where itemid='WB314';
>
>PB
><<<<<<<<
>Maybe this is gilding the lily, but if "specialprice" is null, then
>specialprice < unitprice
>is not true

Read again: ...If( !IsNull( specialprice )...
<<<<<<<<
Right: if
specialprice < unitprice
is true, then "specialprice" is not null. The null-test is absorbed. 

Thread
Complex MySQL Select Statement HelpAngela Barone1 Feb
  • Re: Complex MySQL Select Statement HelpPeter Brawley1 Feb
    • Re: Complex MySQL Select Statement HelpAngela Barone1 Feb
    • Re: Complex MySQL Select Statement Helphsv2 Feb
      • Re: Complex MySQL Select Statement HelpPeter Brawley2 Feb
        • Re: Complex MySQL Select Statement Helphsv3 Feb