Use Orders.OrderDate IS NULL to make it SQL Server compatible :)

>

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

>
>