捷信达酒店管理系统其他消费明细SQL查询语句

捷信达酒店管理系统其他消费明细SQL查询语句

 

 

 

select SUM(Amount)
from gsfoliodetail a  ,
            (
                select a.pcode,a.cname from  gsitem a
                where a.code like '0%' and len(a.pcode) = 6
            ) b
        where ( substring(a.itempcode,1,6) = b.pcode)and  pcode like  '001010%'  
 



select *
from gsfoliodetail a  ,
            (
                select a.pcode,a.cname from  gsitem a
                where a.code like '0%' and len(a.pcode) = 6
            ) b
        where ( substring(a.itempcode,1,6) = b.pcode)and  pcode like  '001010%'  

 

网名：浩秦; 邮箱：root#landv.pw; 只要我能控制一個國家的貨幣發行，我不在乎誰制定法律。金錢一旦作響，壞話隨之戛然而止。