面对库存查询中的问题 [英] Facing problem in stock query

问题描述

嗨


我在QUERY下方使用以维持我的库存但未显示确切结果

Hi
I use below QUERY to maintain my stock but its not show exact result

select p.Product_Name Product,isnull(sum(d.qty),0) Purchase_Qty, isnull(sum(i.qty),0) Issue_Qty, (isnull(sum(d.qty),0)-isnull(sum(i.qty),0)) InStock
from purchase_dtl d left join issue_dpt i on i.Product_ID=d.Product_ID
right join product p on p.id = d.Product_ID
group by p.Product_Name

结果

产品| Purchase_Qty | Issue_Qty | InStock

笔------ 1000 --------- 300 -------- 700

书籍---- 4000 ---- ----- 1000 ------- 3000



我的确切购买

产品| Purchase_Qty

笔------ 500

书籍---- 2000



我的确切问题

产品| Issue_Qty

笔------ 300

书籍---- 1000



请帮我解决我的问题



谢谢

Result
Product|Purchase_Qty|Issue_Qty|InStock
Pen------1000---------300--------700
Books----4000---------1000-------3000

My Exact Purchase
Product|Purchase_Qty
Pen------500
Books----2000

My Exact issue
Product|Issue_Qty
Pen------300
Books----1000

Please Help me to solve my problem

Thanks

推荐答案

试试这个

Hi,
try this

select p.Product_Name Product,isnull(sum(d.qty),0) Purchase_Qty, isnull(sum(i.qty),0) Issue_Qty, (isnull(sum(d.qty),0)-isnull(sum(i.qty),0)) InStock
from purchase_dtl d left join issue_dpt i on i.Product_ID=d.Product_ID
right join product p on p.id = d.Product_ID and p.id=i.Product_ID group by p.Product_Name

尝试这个..

try this..

select p.Product_Name Product,isnull(sum(d.qty),0) Purchase_Qty, isnull(sum(i.qty),0) Issue_Qty, (isnull(sum(d.qty),0)-isnull(sum(i.qty),0)) InStock
from purchase_dtl d,issue_dpt i,product p where i.Product_ID=d.Product_ID
and d.Product_ID=p.id
group by p.Product_Name

这篇关于面对库存查询中的问题的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！