SELECT po.product_id,pop.Qty FROM PurchaseOrder po
INNER JOIN (SELECT id, SUM(quantity) AS Qty FROM PurchaseOrderProduct GROUP BY id) pop
ON pop.id = po.product_id 
WHERE po.number = 'PO1303050001'

quote:

---

Originally posted by visakh16

SELECT po.product_id,pop.Qty FROM PurchaseOrder po
INNER JOIN (SELECT id, SUM(quantity) AS Qty FROM PurchaseOrderProduct GROUP BY id) pop
ON pop.id = po.product_id 
WHERE po.number = 'PO1303050001'

------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/

---