declare vmin:=0 number,vmax:=0 number,OwnerAction:=0 number
select BjuAction into OwnerAction from tbBlackJackdeskUser where BjuBjdId='"+BjdId+"' and BjuIsOwner=1
select nvl(min(BjuAction),0) into vmin,nvl(max(BjuAction),0) into vmax from tbBlackJackdeskUser where BjuBjdId='"+BjdId+"' and BjuIsOwner=0
select OwnerMayState from BlcakJackOwnerState where OwnerAction=OwnerAction and ( OtherMinAction=vmin or vmin=-1 ) and OtherMaxAction=vmax
select BjuAction into OwnerAction from tbBlackJackdeskUser where BjuBjdId='"+BjdId+"' and BjuIsOwner=1
select nvl(min(BjuAction),0) into vmin,nvl(max(BjuAction),0) into vmax from tbBlackJackdeskUser where BjuBjdId='"+BjdId+"' and BjuIsOwner=0
select OwnerMayState from BlcakJackOwnerState where OwnerAction=OwnerAction and ( OtherMinAction=vmin or vmin=-1 ) and OtherMaxAction=vmax
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货