How do I modify this statement to include Customers without any Orders...?


-------------------------
Beware of programmers with screwdrivers...

Use a left outer join instead of an inner join

SELECT * FROM (SELECT CustomerID, Count(*), max(date) FROM tblOrders GROUP BY CustomerID) AS a, tblCustomers AS b WHERE b.CustomerID *= a.CustomerID