主题：请教SQL语句写法

楼主需要从三个表提取数据的，二楼的代码好像不行的哦xssj_2009和xssj_2010 好像是两个表啊

试试这个：

;with am as
(
select a.区,sum(b.销售金额),sum(b.销售成本),sum(b.销售税) from jcxx a,xssj_2009 b where a.sku=b.sku and b.日期 between '2009-12-1' and '2009-12-31' group by a.区

union
select a.区,sum(b.销售金额),sum(b.销售成本),sum(b.销售税) from jcxx a,xssj_2010 b where a.sku=b.sku and b.日期 between '2010-1-1' and '2010-1-31' group by a.区
)
select a.区,sum(b.销售金额) as 销售金额,sum(b.销售成本) as 销售成本,sum(b.销售税) as 销售税  from am group by a.区