>>I can't figure out why these two select statements give me different results. The only difference is the where clause.
>>
>>select sum(scordln.orl_qty-scordln.orl_qtyinvoiced) as nqty ;
>>from scordln left outer join scorder ;
>>on scordln.orl_order = scorder.ord_order ;
>>where between(scorder.ord_acct,1,201) ;
>>into cursor cqty
>>
>>select sum(scordln.orl_qty-scordln.orl_qtyinvoiced) as nqty ;
>>from scordln left outer join scorder ;
>>on scordln.orl_order = scorder.ord_order ;
>>where scorder.ord_acct < 201 ;
>>into cursor cqty
>>
>>Thanks
>>
>>Pat Murphy
>
>The between() in the first gets between 1 and 201 *inclusively*
>The second excludes 201.
>The make them the same either change the first to
>
where between(scorder.ord_acct,1,200)
>or the second to
>
where scorder.ord_acct <= 201
The second is that the < operator includes 0 or negative values that might exists; 0, which could be a default for a null or empty assignment, might be a significant factor.