[RESOLVED] Sub Query Problem

[nUflAvOrS]

SELECT SUM(SELECT (Qty * U_cost) as SubCost 
       FROM Prod_Detail 
       WHERE PCRefNo = @PCRefNo AND Product_Code = @PCode) AS TotalCost 
FROM Prod_Detail
WHERE PCRefNo = @PCRefNo AND Product_Code = @PCode

What problem of my query ?

Prompt out Incorrect Syntax near the keyword 'SELECT'

[jmcilhinney]

You can't sum a sub query. If you want to sum the result of multiplying Qty and U_cost then that's exactly what you should do:

SELECT SUM(Qty * U_cost) AS TotalCost
FROM Prod_Detail
WHERE PCRefNo = @PCRefNo AND Product_Code = @PCode

[nUflAvOrS]

Thanks a lot ,

Problem Solved ...