Sundaram Murugan
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:
Post a Comment
Newer Post
Older Post
Home
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment