西軟報表處理語句相關

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 * 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

網名：浩秦;

郵箱：root#landv.pw;

隻要我能控制一個國家的貨幣發行，我不在乎誰制定法律。金錢一旦作響，壞話隨之戛然而止。