{ One of the columns in P is a BLOB }

Select P.*, Sum(S.Stock) As Stock
from Product
P Left Outer Join StockLocation S On S.ProductID = P.ID
Where P.ID=10
Group By ID