SELECT numero_caf,CODIGOIDENTIFICACION_PAD,(VALORIVA_CAF) as VALORIVA_CAF,(round(TOTAL_CAF,2))as TOTAL_CAF, (NUMEROCOMPROBANTES) as NUMEROCOMPROBANTES from (SELECT numero_caf,CODIGOIDENTIFICACION_PAD,(VALORIVA_CAF) as VALORIVA_CAF,(round(TOTAL_CAF,2))as TOTAL_CAF, (serial_caf) as NUMEROCOMPROBANTES  from sritipotransaccion,padres,padres_alumno,paralelo_alumno,cabecerafactura where sritipotransaccion.identificacion_ttr=padres.tipoidentificacion_pad and sritipotransaccion.transaccion_ttr='VENTA' and paralelo_alumno.serial_paralu=cabecerafactura.serial_paralu and padres.serial_pad=padres_alumno.serial_pad and padres_alumno.serial_alu=paralelo_alumno.serial_alu and estado_caf<>'ANULADA' and YEAR(fecha_caf)='2015' and MONTH(fecha_caf)='07' and repreEconomico_palu='SI'   UNION SELECT numero_orp as numero_caf,if (CEDULA_ORP ='',DOCUMENTOIDENTIDAD_CLI,CEDULA_ORP) as CODIGOIDENTIFICACION_PAD,(SUMAIVA12_ORP) as VALORIVA_CAF,(TOTAL_ORP)as TOTAL_CAF, (serial_orp) as NUMEROCOMPROBANTES   from sritipotransaccion,cliente,ordenpedido where  cliente.serial_cli=ordenpedido.serial_cli and  sritipotransaccion.identificacion_ttr=if (length(cedula_orp)<=0,tipodocumento_cli,if(length(cedula_orp)>10,'RUC','CEDULA')) and sritipotransaccion.transaccion_ttr='VENTA' and estado_orp='FACTURADO' and YEAR(fecha_orp)='2015' and MONTH(fecha_orp)='07' order by numero_caf  ) AS facturasventa order by numero_caf