>>

>>SELECT Customer.CustomerID, Customer.CustName, Orders.OrderID, ;
>>			Orders.OrderDate, Orders.Destination ;
>>	FROM Customer ;
>>		LEFT OUTER JOIN orders ON Orders.CustomerID = Customer.CustomerID ;
>>	WHERE OrderDate = ( SELECT MAX(OrderDate) FROM Orders Recent WHERE Recent.CustomerID = Orders.CustomerID) 
>>

>
>Now I've got a new twist on this - I need to include ALL customers, even those without an order. The above SQL filters those out. I've been beating my head against it without success. Any ideas?

You may add UNION to your original select to get customers without orders.

E.g.

SELECT CUST.CustomerID, ;
		CUST.CompanyName, Orders.OrderID, Orders.OrderDate, ;
		Orders.ShipRegion FROM Customers CUST;
		INNER JOIN Orders ON Orders.CustomerID = CUST.CustomerID ;
		INNER JOIN (SELECT MAX(OrderDate) AS Max_Date, CustomerID ;
		FROM Orders GROUP BY CustomerID) MaxOrders ON Orders.CustomerID = MaxOrders.CustomerID AND ;
		Orders.OrderDate = MaxOrders.Max_Date INTO CURSOR curResults2
UNION 
SELECT CUST.CustomerID, ;
		CUST.CompanyName, cast(0 as Integer) as OrderID, {} as OrderDate, 
cast('' as char(10)) as ShipRegion from Customers LEFT JOIN Orders on Customers.OrderID = Orders.OrderID 
where Orders.OrderID IS NULL

Another way

SELECT Customer.CustomerID, Customer.CustName, Orders.OrderID, ;
			Orders.OrderDate, Orders.Destination ;
	FROM Customer ;
		LEFT OUTER JOIN orders ON Orders.CustomerID = Customer.CustomerID ;
	WHERE OrderDate = ( SELECT MAX(OrderDate) FROM Orders Recent 
WHERE Recent.CustomerID = Orders.CustomerID)  or Orders.OrderID IS NULL