Con un JOIN
Código SQL:
Ver originalSELECT *
FROM (SELECT c.clacli, SUM((fl.precio-((fl.precio*fl.dto)/100))*fl.cantidad) AS 'TOTAL 2012'
FROM clientes c, factura f, factural fl, articulo a
WHERE c.clacli=f.clacli AND f.clafac=fl.clafac AND fl.claart=a.claart AND a.clacat=21 AND YEAR(f.fecha)=2012
GROUP BY c.clacli) AS A
INNER JOIN (
SELECT c2.clacli AS 'CÓDIGO', c2.nombre AS 'NOMBRE', c2.direccion AS 'DIRECCIÓN', c2.localidad AS 'LOCALIDAD', c2.telefono AS 'TELÉFONO', c2.contacto AS 'CONTACTO', c2.provincia AS 'PROVINCIA', tar.nombre AS 'TARIFA'
FROM clientes c2, tiposcli tipos, codpais cod, tarifa tar
WHERE c2.clatar=tar.clatar
AND c2.clatip=tipos.clatip
AND c2.clapai=cod.clapai
GROUP BY c2.clacli) AS B ON
A.clacli = B.CODIGO