select s.SellerName
from seller s
inner join product p
on p.sellerID = s.sellerID
group by s.SellerName
having sum(case when isSold=0 then 1 else 0 end) >0
------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/
select statement help
Posted - 05/05/2012 : 12:11:33
