主题
帖子
在线时间 小时
鲜花 朵
金币 个
贡献 点
精华
注册时间2012-1-12
最后登录1970-1-1
|
SELECT SALEMANADAY.SMDMARKET,
SALEMANADAY.SMDMFID,
SUM(SALEMANADAY.SMDSJJE) SMDSJJE,
SUM(SALEMANADAY.SMDTOTZK) SMDTOTZK,
SUM(SALEMANADAY.SMDXSSR) SMDXSSR,
SUM(SALEMANADAY.SMDCASH) XJ,
SUM(SALEMANADAY.SMDCHECK) ZP,
SUM(SALEMANADAY.SMDCCARD) XYK,
SUM(SALEMANADAY.SMDFCARD) MZK,
SUM(SALEMANADAY.SMDGCERT) LQ,
SUM(SMDOPAY) QTFS
FROM SALEMANADAY
WHERE ( SALEMANADAY.SMDDATE >= TO_DATE('2012-01-13','YYYY-MM-DD') AND SALEMANADAY.SMDDATE < TO_DATE('2012-01-13','YYYY-MM-DD') + 1 ) AND
'SALEMANADAY.SMDTPID'='SALEMANADAY.SMDTPID' AND
SALEMANADAY.SMDMARKET = '3010' AND
'SALEMANADAY.SMDMFID'='SALEMANADAY.SMDMFID' AND
'++SALEMANADAY.SMDMFID'='++SALEMANADAY.SMDMFID'
GROUP BY SALEMANADAY.SMDMARKET,
SALEMANADAY.SMDMFID |
|