This is the one in 7.1 (this one works fine):

Code:
SELECT "CXCDHIST"."CLIENTE", "CXCDHIST"."FECHA", "CXCDHIST"."DOCUMENTO", "CXCDHIST"."TIQUETEFISCAL", "CXCDHIST"."TOTAL", "CXCDHIST"."TRANSACCION", "CXCDHIST"."RECNUM", "CXCDMAES"."CLIENTE", "CXCDMAES"."NOMBCLTE", "CXCDMAES"."DIREC01", "CXCDMAES"."DIREC02", "CXCDMAES"."TELEFONO", "CXCDMAES"."TELEOFICINA_1", "CXCDMAES"."TELEFAX", "CXCDMAES"."NOMCIUDAD", "CXCDMAES"."EMAIL", "CXCDMAES"."CIA", "CXCDMAES"."OCLIENTE", "COMPANIA"."NOMBRE", "COMPANIA"."RUC", "COMPANIA"."DV", "COMPANIA"."ECTACXCMOSTRARTIQFISCAL", "COMPANIA"."MOSTRARLOGOENECTACXC", "COMPANIA"."IMAGEN", "COMPANIA"."MOSTRARPIEDEECTACXC", "COMPANIA"."TELEFONO_1", "COMPANIA"."TELEFONO_2", "COMPANIA"."TELEFAX_1", "COMPANIA"."APARTADO", "COMPANIA"."DIRECCION", "COMPANIA"."NOTAPIEDEECTACXC" FROM "dbo"."CXCDHIST" "CXCDHIST" LEFT OUTER JOIN  "dbo"."CXCDMAES" "CXCDMAES" ON ("CXCDHIST"."CIA" = "CXCDMAES"."CIA") AND ("CXCDHIST"."CLIENTE" = "CXCDMAES"."CLIENTE") INNER JOIN  "dbo"."COMPANIA" "COMPANIA" ON ("CXCDHIST"."CIA" = "COMPANIA"."CIA") WHERE "CXCDMAES"."CIA"='90' AND "CXCDMAES"."CLIENTE">='0001'  ORDER BY "CXCDHIST"."FECHA"
Same report.