cytj.txt

着是一个酒店管理的系统着是一个酒店管理的系统

select sum(ssje_xj) into :xjje from t_cy_czzd where ctbh=:ctbh and zdzt=2 and rq1>=:rq1 and rq1<:rq2;

select sum(ysje) into :qdje from t_cy_czzd where ctbh=:ctbh and zdzt=2 and rq1>=:rq1

select sum(ssje_qt) into :qtje from t_cy_czzd where ctbh=:ctbh and zdzt=2 and rq1>=:rq1



select sum(ysje) into :zhys from t_cy_czzd where ctbh=:ctbh and zdzt=2 and rq1>=:rq1 and rq1<:rq2;