Home >> Asked Questions >> Mysql

SELECT ord.cust_id, c.name, MAX(ord.payment)
FROM orders AS ord, customers AS c
WHERE ord.custid = c.custid
GROUP BY o.custid;