西软报表处理语句相关

select s.staffcd, s.staffname, s.staffpassword, o.objectcd as deptcd, o.companyname as deptdrpt
from castaff s left outer join caorg o on s.deptcd=o.objectcd and o.objecttype='2'
where s.staffcd<>'' and s.roleclass<>'3'
order by o.companyname, s.staffname

 

 

select v.no,v.src,v.name,c.chotelid,c.accnt,c.crttime,c.type,c.ratecode,c.idays,c.rm,c.fb,c.tl from vipcard_consume
as c,vipcard as v where c.cid=v.id and v.no ='888000025' ORDER BY v.no

 

 

select v.no,v.src,v.name,c.chotelid,c.accnt,c.crttime,c.type,c.ratecode,c.idays,c.rm,c.fb,c.tl from vipcard_consume
as c,vipcard as v where c.cid=v.id and v.no ='888000025' ORDER BY v.no

select * from vipcard_consume

C171230000003

select * from vipcard_consume where cardno ='888000025' /*主单里面的*/

/*消费明细*/
select
d.no,d.grp,d.flag,d.cardno,d.consume_no,d.cost_on,d.bdate,d.cost,d.feecode,d.payment,d.oper,d.oper_on,d.belong from
vipcard_consume_dtls as d
where d.hotelid = '#{card_hotelid}#' and d.cardno = '#{card_no}#' and d.consume_no = '#{card_id}#' order by d.no
desc