Tienes razon: me equivoque..
Espero que esto es correcto:
Código SQL:
Ver originalSELECT C.CompanyName,
O.ShipCountry,
O.ShippedDate
FROM Customers C
OUTER Apply (SELECT ShipCountry,
MAX(ShippedDate) ShippedDate
FROM Orders O
WHERE O.CustomerID=C.CustomerID
GROUP BY ShipCountry) O;