 <p>Have a go with this:</p> <pre><code>SELECT C.CustID, C.FirstName + ', ' + C.LastName AS CustomerName, O1.OrderDate FROM Customers C INNER JOIN ( SELECT CustID FROM Orders WHERE month(OrderDate) IN (1,2) ) O1 ON C.CustID=O1.CustID LEFT JOIN ( SELECT CustID FROM Orders WHERE month(OrderDate) IN (3) ) O2 ON C.CustID=O2.CustID WHERE O2.CustID IS NULL GROUP BY C.CustID, C.FirstName, C.LastName, O1.OrderDate </code></pre>