原帖由 closeyoureyes 于 2007-8-3 10:16 发表
SELECT sum(1) AS GP
FROM [SELECT A.BSC,A.BTS,SUM(TCH) AS PDTCH,B.CDED,B.CDEF FROM
TRXPAR A,BTSPAR B
WHERE
A.BSC=B.BSC
AND int(right(A.BTS,4))=int(B.BTS)
AND A.GTRX="Y"
GROUP BY A.B ...
欢迎光临 Office中国论坛/Access中国论坛 (http://www.office-cn.net/) | Powered by Discuz! X3.3 |