按理说我要的结果应该是只有 杂支 和 广告费 这两项，请问各位，这是怎么回事。请指点，多谢！！！！！！SELECT I.S_FeeText, SUM(I.F_PayMoney) AS F_FeeMoney ,CONVERT(varchar(10),T.DT_DataTime, 23) from dbo.T_FeeDocItem AS I INNER JOIN dbo.T_FeeDocTitel AS T ON T.S_SerialNO = I.S_SerialNO GROUP BY I.S_FeeText, CONVERT(varchar(10),T.DT_DataTime, 23) SELECT I.S_FeeText, SUM(I.F_PayMoney) AS F_FeeMoney ,T.DT_DataTime
from dbo.T_FeeDocItem AS I INNER JOIN dbo.T_FeeDocTitel AS T ON T.S_SerialNO = I.S_SerialNO GROUP BY I.S_FeeText,T.DT_DataTime
你的SQL语句里面有DT_DataTime这个列啊，删除就可以了！
SELECT I.S_FeeText, SUM(I.F_PayMoney) AS F_FeeMoney
from dbo.T_FeeDocItem AS I INNER JOIN dbo.T_FeeDocTitel AS T ON T.S_SerialNO = I.S_SerialNO GROUP BY I.S_FeeText,T.DT_DataTime
第一句: select ht.gfdm,gfdm.gfmc,gfdm.lb ,sum(jh.htdj*jh.htsl)as je from ht left join gfdm on ht.gfdm=gfdm.gfdm join jh on ht.htbh=jh.hth and ht.htbh not like'del%' and ht. ......
