Hi,
You're getting only one product because you're using
INNER JOIN. So use
LEFT JOIN instead. Also, you need to replace
NULL values with
0. Your query should be like this:
SELECT ProductId, IIF(InitialStock IS NULL, 0, InitialStock) + SUM(IIF(ReceivedQty IS NULL, 0, ReceivedQty)) AS TotalQty
FROM ProductStock AS PSD LEFT JOIN ReceivedProducts AS RP ON PSD.ProductId = RP.Product
GROUP BY PSD.ProductId, InitialStock;
Please let me know how it works.