Sunday, December 13, 2009

Left Outer join with Having in SQL Server




select p.[ProductName],count(po.ProductID)
from Products as p Left Outer join
Productorder po on p.ProductID=po.productID
GROUP By p.[ProductName],po.ProductID
HAVING (count(po.ProductID) > 0)

No comments: