Hi All, I wrote the following Query SELECT Item.Description,Item.[No_],POC.[Qty on Component Line] FROM [Company Name$Item] AS Item LEFT OUTER JOIN (SELECT [Item No_],Status,Sum([Remaining Quantity]) AS [Qty on Component Line] FROM [Company Name$Prod_ Order Component] Group By Status, [Item No_]) AS POC ON Item. [No_] = POC.[Item No_] AND ((POC.Status = 1) OR (POC.Status = 2) OR (POC.Status = 3)) WHERE (Item.[Buy on Hold] = 1) AND Item.[No_] = '01-12008'With this query what i want to acheive is that for the item '01-12008' i should have only one record as a result.but what i am getting is 2 records because the POC table has 4 lines, 3 for status = 2 and 1 for status = 1. I am getting the sum of Remaining Qty from POC table for status = 2. What i want is that it should give only 1 record as result by summing up the quantity for POC table if status is 1 or 2 or 3.