I have tried with Left Join but no luck...Please Guide that how to this resultset which should based on condition
that Sales.sDate='2012-01-01' and Sales.UserID=101 and all the rows from Products Table Should be reterive either the saleQty is available or not in Sales Table.
, COALESCE(SUM(s.SaleQty,0) AS SaleQty
FROM Products AS p
JOIN Sales AS s
ON s.ItemID = p.ItemID
AND s.sDate = '2012-01-01'
AND s.UserID = 101