select
a.id,
入库=isnull(b.数量,0),
出库=isnull(c.数量,0),
库存=a.数量
from
kc a
left join
(select id,sum(数量) as 数量 from rk group by id) b
on
a.id=b.id
left join
(select id,sum(数量) as 数量 from ck group by id) c
on
a.id=c.id
order by
a.id
a.id,
入库=isnull(b.数量,0),
出库=isnull(c.数量,0),
库存=a.数量
from
kc a
left join
(select id,sum(数量) as 数量 from rk group by id) b
on
a.id=b.id
left join
(select id,sum(数量) as 数量 from ck group by id) c
on
a.id=c.id
order by
a.id
(select isnull(sum(数量),0) from rk where id=A.id) as 入库,
(select isnull(sum(数量),0) from ck where id=A.id) as 出库,
(select isnull(sum(数量),0) from kc where id=A.id) as 库存
from
(
select id from rk
union
select id from ck
) A