solo modificas los campos a mostrar:
Código SQL:
Ver originalSELECT orderid,CompanyName,ShipCountry,ShippedDate FROM Customers AS t1
LEFT JOIN
(
SELECT customerid,ShippedDate,orderid,ShipCountry
FROM orders WHERE orderid IN (
SELECT MAX(orderid) FROM orders GROUP BY shipcountry)
) AS t2 ON (t1.customerid=t2.customerid)
WHERE t2.OrderID IS NOT NULL
saludos!