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 ; INNER JOIN orders ON Orders.CustomerID = Customer.CustomerID ; WHERE OrderDate = ( SELECT MAX(OrderDate) FROM Orders Recent WHERE Recent.CustomerID = Orders.CustomerID) UNION SELECT Customer.CustomerID, Customer.CustName, Orders.OrderID, ; Orders.OrderDate, Orders.Destination ; FROM Customer ; LEFT JOIN orders ON Orders.CustomerID = Customer.CustomerID where orders.OrderID IS NULLOR
SELECT Customer.CustomerID, Customer.CustName, Orders.OrderID, ; Orders.OrderDate, Orders.Destination ; FROM Customer ; INNER JOIN orders ON Orders.CustomerID = Customer.CustomerID ; AND OrderDate = ( SELECT MAX(OrderDate) FROM Orders Recent WHERE Recent.CustomerID = Orders.CustomerID)