select
a.prd,a.dept,
月份=convert(char(7),date,120),
销售额=sum(a.money),
退货额=sum(b.money)
from ta a,tb b where a.prd=b.prd and a.dept=b.dept
group by a.prd,a.dept,convert(char(7),date,120)
a.prd,a.dept,
月份=convert(char(7),date,120),
销售额=sum(a.money),
退货额=sum(b.money)
from ta a,tb b where a.prd=b.prd and a.dept=b.dept
group by a.prd,a.dept,convert(char(7),date,120)
select (a.fhmoney - b.thmoney)as jr from (select * from a left outer join b on a.prdname= b.proj_name and
a.deptname=b.deptname and month(a.carddt)= month(b.carddt))
但是会报错:
服务器: 消息 170,级别 15,状态 1,行 2
第 2 行: ')' 附近有语法错误。
请高手帮忙看看!