Ver originalSELECT CompanyName,t2.customerid,t2.max_fecha FROM Customers AS t1LEFT JOIN (SELECT customerid,MAX(ShippedDate) max_fechaFROM orders GROUP BY customerid) AS t2 ON (t1.customerid=t2.customerid)