select sum(emoney) as emoney from set_emoney where upper(mbid)='' and status='Y'
select sum(snum) as epoint from set_point where upper(mbid)='' and status='Y'
select sum(emoney) as emoney from set_emoney where mbid='' and status = 'Y' and emoney <0
select sum(emoney) as emoney from set_emoney where mbid='' and status = 'Y' and pkind='H'
select sum(emoney) as emoney from set_emoney where mbid='' and status = 'N' and pkind='H'
select sum(snum) as snum from set_point where mbid='' and status = 'Y' and snum <0
select sum(snum) as snum from set_point where mbid='' and status = 'N' and pkind='Z'
select org_sum,per_sum,per_sumo,bgradename from mst where mbid=''
請先登入!!
會員卡別
續約日
紅利金釋放中
0
紅利金可使用
0
紅利金已提領
0
總累積消費PV
0