>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