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