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