select OMInc from psOrderMain where MemID='' and SuccessYes=0 and DeleteYes=0
query error!query error!query error!
select *
from psCateMainBatch where 1=1 and (Depth=1 or Depth=2)
order by CBInc asc
query error!
select
DMInc,CustKind,CustID,ServiceID,VenID,ScopeS,ScopeE,DC,SPriceYes,MPriceYes,BuyCnt,CreateDate,CreateDate8,CreateOper,ModifyDate,ModifyDate8,ModifyOper
from
psDCMain
where
(
( SPriceYes=1 and ScopeS <= 0 and 0 <= ScopeE )
or ( SPriceYes=5 and ScopeS <= 0 and 0 <= ScopeE )
or ( SPriceYes=6 and ScopeS <= 0 and 0 <= ScopeE )
or ( SPriceYes=0 and ScopeS <= 0 and 0 <= ScopeE )
or ( SPriceYes=3 and ScopeS <= 0 and 0 <= ScopeE )
or ( SPriceYes=4 and ScopeS <= 0 and 0 <= ScopeE )
or ( SPriceYes=2 and ((0+1) % BuyCnt)=0 and (0+1) <> 0)
)
and MPriceYes <> 2
select
DMInc,CustKind,CustID,ServiceID,VenID,ScopeS,ScopeE,DC,SPriceYes,MPriceYes,BuyCnt,CreateDate,CreateDate8,CreateOper,ModifyDate,ModifyDate8,ModifyOper
from
psDCMain
where
(
( SPriceYes=1 and ScopeS <= 0 and 0 <= ScopeE )
or ( SPriceYes=5 and ScopeS <= 0 and 0 <= ScopeE )
or ( SPriceYes=6 and ScopeS <= 0 and 0 <= ScopeE )
or ( SPriceYes=0 and ScopeS <= 0 and 0 <= ScopeE )
or ( SPriceYes=3 and ScopeS <= 0 and 0 <= ScopeE )
or ( SPriceYes=4 and ScopeS <= 0 and 0 <= ScopeE )
or ( SPriceYes=2 and ((0+1) % BuyCnt)=0 and (0+1) <> 0)
)
and MPriceYes <> 2