Problema con función Máx e Inner Join

[gnzsoloyo]

Hay muchas formas de hacerlo:

Código MySQL:

SELECT 
    C.firstname, 
    C.lastname, 
    max(O.total_paid) 
FROM 
    ps_customer C
    INNER JOIN ps_orders O ON C.id_customer = O.id_customer
GROUP BY C.id_customer
LIMIT 1;
 

O bien:

Código MySQL:

SELECT 
    C.firstname, 
    C.lastname, 
    O.total_paid
FROM 
    ps_customer C
    INNER JOIN ps_orders O ON C.id_customer = O.id_customer
HAVING O.total_paid = MAX(O.total_paid) ;