MySQL - subconsulta correlacionada

select * from cliente, factura where factura.importe= (select max(importe) from factura);

SELECT A.NROCLIENTE,

  MAX( B.IMPORTE )

         FROM CLIENTE A,

              FACTURA B

 WHERE A.NROCLIENTE = B.NROCLIENTE

 GROUP BY A.NROCLIENTE

SELECT

	cl.nombres AS 'Cliente',

	Max(fa.importe) AS 'Importe'

FROM

	factura fa

INNER JOIN clientes cl ON cl.id_cliente = fa.id_cliente

GROUP BY

	fa.id_cliente