Select a.产品编号,Sum(a.数量) as 总入库数量 ,Sum(b.数量) as 总出库数量,
(sum(a.数量)-sum(b.数量)) as 库存量 from
(Select 产品编号,Sum(数量) as 总入库数量
from 入库单明细
Group by 产品编号) a inner join (Select 产品编号,Sum(数量) as 总出库数量
from 出库单明细
Group by 产品编号) b
on on a.产品编号=b.产品编号
(sum(a.数量)-sum(b.数量)) as 库存量 from
(Select 产品编号,Sum(数量) as 总入库数量
from 入库单明细
Group by 产品编号) a inner join (Select 产品编号,Sum(数量) as 总出库数量
from 出库单明细
Group by 产品编号) b
on on a.产品编号=b.产品编号
更正
Select a.产品编号,a.总入库数量 ,b.总出库数量,
a.总入库数量-b.总出库数量 as 库存量 from
(Select 产品编号,Sum(数量) as 总入库数量
from 入库单明细
Group by 产品编号) a inner join (Select 产品编号,Sum(数量) as 总出库数量
from 出库单明细
Group by 产品编号) b
on on a.产品编号=b.产品编号
再更正Select a.产品编号,a.总入库数量 ,ISNULL(b.总出库数量,0) as 总出库数量,
a.总入库数量-ISNULL(b.总出库数量,0) as 库存量 from
(Select 产品编号,Sum(数量) as 总入库数量
from 入库单明细
Group by 产品编号) a left join (Select 产品编号,Sum(数量) as 总出库数量
from 出库单明细
Group by 产品编号) b
on on a.产品编号=b.产品编号
Sum(isnull(a.数量,0)) as 总入库数量 ,
Sum(isnull(b.数量,0)) as 总出库数量,
(sum(isnull(a.数量,0))-sum(isnull(b.数量,0))) as 库存量
from 入库单明细 a full join 出库单明细 b
on a.产品编号=b.产品编号
Group by a.产品编号
Sum(isnull(a.数量,0)) as 总入库数量 ,
Sum(isnull(b.数量,0)) as 总出库数量,
(sum(isnull(a.数量,0))-sum(isnull(b.数量,0))) as 库存量
from 入库单明细 a full join 出库单明细 b
on a.产品编号=b.产品编号
Group by isnull(a.产品编号,b.产品编号)
from (
select 产品名称,sum(数量) as 总入库数量 from 入库单明细 group by 产品名称
) as a full join
(
select 产品名称,sum(数量) as 总出库数量 from 出库单明细 group by 产品名称
) as b
on a.产品名称=b.产品名称
from (
select 产品名称,sum(数量) as 总入库数量 from 入库单明细 group by 产品名称
) as a full join
(
select 产品名称,sum(数量) as 总出库数量 from 出库单明细 group by 产品名称
) as b
on a.产品名称=b.产品名称
sum(入库数量)-sum(出库数量) as 库存from (
select 产品名称,入库数量=数量,出库数量=0 from 入库单明细
union all
select 产品名称,入库数量=0,出库数量=数量 from 出库单明细
) as agroup by 产品名称