eugene-sh

SELECT
   [Name], *
FROM
   Customer AS c 
   inner join
      Purchaise AS p 
      ON c.CustomerId = p.CustomerId 
WHERE
   p.ProductNameN = N'Молоко' 
   and c.CustomerId not in