主题：求调拨汇总

 用下面的代码，关键，是还原这张表，建议红色代码做一个视图，或临时表，因为是重复的。

select 分公司, (select sum(数量) from
(select 购入公司 as 分公司, 单据, "购入" as 性质, 数量 from {表A}  where 购入公司
union all
select 调入公司 as 分公司, 单据, "调入" as 性质, 数量 from {表A} where 调入公司) as a where a.分公司 = b.分公司 and 单据 = '购入') as 购入,
(select sum(数量) from
(select 购入公司 as 分公司, 单据, "购入" as 性质, 数量 from {表A}  where 购入公司
union all
select 调入公司 as 分公司, 单据, "调入" as 性质, 数量 from {表A} where 调入公司) as a where a.分公司 = b.分公司 and 单据 = '调拨' and 性质='购入') as 调入,
 (select sum(数量) from
(select 购入公司 as 分公司, 单据, "购入" as 性质, 数量 from {表A}  where 购入公司
union all
select 调入公司 as 分公司, 单据, "调入" as 性质, 数量 from {表A} where 调入公司) as a where a.分公司 = b.分公司 and 单据 = '调拨' and 性质 = '调入') as 调出
from
(select 购入公司 as 分公司 from {表A}  where 购入公司
union
select 调入公司 as 分公司 from {表A} where 调入公司) as b

自己参考改一改即可。不然，就直接用之前的代码。