SQL Code:
  1. SELECT SUM(SELECT (Qty * U_cost) as SubCost
  2.        FROM Prod_Detail
  3.        WHERE PCRefNo = @PCRefNo AND Product_Code = @PCode) AS TotalCost
  4. FROM Prod_Detail
  5. WHERE PCRefNo = @PCRefNo AND Product_Code = @PCode

What problem of my query ?

Prompt out Incorrect Syntax near the keyword 'SELECT'