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)>>
>>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) >>>