/////////7  buscar serial_par  ///////

SELECT nombre_niv, nombre_par, paralelo.serial_par
FROM `paralelo` , nivel
WHERE nivel.serial_niv = paralelo.serial_niv
AND `serial_per` =6


//////  actualizacion de cobros por mes para el reporte cxc  ///////

UPDATE alumnopagos,
(
SELECT paralelo_alumno.serial_paralu, sum( total_caf ) AS total_caf
FROM alumnopagos, periodo, meses, alumno, nivel, paralelo, paralelo_alumno, cabecerafactura
LEFT JOIN notacredito ON notacredito.serial_caf = cabecerafactura.serial_caf
WHERE paralelo_alumno.serial_per = periodo.serial_per
AND alumnopagos.serial_paralu = paralelo_alumno.serial_paralu
AND nivel.serial_niv = paralelo.serial_niv
AND paralelo.serial_par = paralelo_alumno.serial_par
AND paralelo_alumno.serial_paralu = cabecerafactura.serial_paralu
AND alumno.serial_alu = paralelo_alumno.serial_alu
AND meses.serial_mes = cabecerafactura.mes_caf
AND tipo_caf = 'PENSIONES'
AND periodo.serial_per =6
AND meses.serial_mes =8
AND alumnopagos.serial_mes =8
AND ESTADO_CAF = 'PAGADA'
AND paralelo_alumno.serial_par =164
GROUP BY paralelo_alumno.serial_paralu
) AS b
SET alumnopagos.valor_mes = b.total_caf WHERE alumnopagos.serial_paralu = b.serial_paralu AND alumnopagos.serial_mes =8  [] []