入库详情 出库详情 计算库存的 sql

Question

有两张表
入库详情
出库详情
怎么计算某个仓库 当前库存呢 求sql server 语句
谢谢大佬！

Answer 1

 select table_in.GoodsId,(table_in.Amount - table_out.Amount) from (
  select GoodsId ,Id,sum(Amount) Amount from Test_LGL_EntryInfo Group by GoodsId,Id
    ) table_in left join(
    select GoodsId ,Id,sum(Amount) Amount from Test_LGL_OutboundInfo Group by GoodsId,Id
   )table_out on table_in.GoodId = table_out.GoodsId where table_in.Id =仓库ID