SELECT c.CustomerID
      ,c.FirstName
      ,c.LastName
      ,c.CompanyName
      ,c.BillingAddress1
      ,c.BillingAddress2
      ,c.City
      ,c.State
      ,c.PostalCode
      ,c.Country
      ,c.EmailAddress
  FROM Customers AS c
  WHERE NOT EXISTS 
		(SELECT *
		 FROM Orders AS o
		 WHERE o.CustomerID = c.CustomerID AND
		       o.OrderDate BETWEEN '2010-04-01' AND '2010-04-30'
		) AND
		  c.AccessKey = 'C' AND
		  c.LastLogin BETWEEN '2010-04-01' AND '2010-04-30'
  ORDER BY c.CustomerID
GO