sql子查询两个表的数据相减

现有表atable和表btable，数据如下：

table atable

id    anumber

1       500

2       300

3       400

table btable

id    bnumber

1        501

2        301

3        401

总数据相减：

sql:

select  (select  sum(a.number) from a atable) - (select sum(b.number) from b btable)  as '总数据'

每条字段相减:

sql:

select id,sum(anumber),sum(bnumber),sum(anumber-bnumber) from

(select  sum(a.number) from a atable)

union all

(select sum(b.number) from b btable)

加的符号改一下就可以了