| Respuesta: Consulta usando Swhit de mysql
estan son las dos tablas con q trabajo
--
-- Estructura de tabla para la tabla `estudiantes`
--
CREATE TABLE `estudiantes` (
`codest` varchar(12) COLLATE utf8_unicode_ci NOT NULL,
`cedpadre` varchar(20) CHARACTER SET utf8 COLLATE utf8_spanish_ci NOT NULL,
`cedest` varchar(20) COLLATE utf8_unicode_ci NOT NULL,
`pnomest` varchar(40) CHARACTER SET utf8 COLLATE utf8_spanish_ci NOT NULL,
`snomest` varchar(40) CHARACTER SET utf8 COLLATE utf8_spanish_ci NOT NULL,
`papeest` varchar(40) CHARACTER SET utf8 COLLATE utf8_spanish_ci NOT NULL,
`sapeest` varchar(40) CHARACTER SET utf8 COLLATE utf8_spanish_ci NOT NULL,
`sexoest` varchar(10) CHARACTER SET utf8 COLLATE utf8_spanish_ci NOT NULL,
`direcest` text COLLATE utf8_unicode_ci NOT NULL,
`fnacest` date NOT NULL,
`coddoc` int(11) NOT NULL,
`codnivel` int(11) NOT NULL,
`codgrado` int(11) NOT NULL,
`codturno` int(11) NOT NULL,
`codperiodo` int(11) NOT NULL,
`becado` varchar(10) COLLATE utf8_unicode_ci NOT NULL,
`statusest` int(2) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
--
-- Volcado de datos para la tabla `estudiantes`
--
INSERT INTO `estudiantes` (`codest`, `cedpadre`, `cedest`, `pnomest`, `snomest`, `papeest`, `sapeest`, `sexoest`, `direcest`, `fnacest`, `coddoc`, `codnivel`, `codgrado`, `codturno`, `codperiodo`, `becado`, `statusest`) VALUES
('A02409930', '18765432', '27541237', 'CARLOS', '', 'VARGAS', 'NAVI', 'MASCULINO', 'AV. BENI MAMORE', '2009-07-14', 1, 2, 1, 1, 1, 'NO', 1),
('A19EF297C', '18765432', '21123456', 'RAFAEL DE JESUS', '', 'CONTRERAS', 'QUINTERO', 'MASCULINO', 'SANTA CRUZ DE MORA', '2002-12-14', 1, 2, 1, 1, 1, 'MEDIA', 1),
('A1A407ACA', '81321310', '21456234', 'RUBEN', 'DARIO', 'CHIRINOS', 'PAREDES', 'MASCULINO', 'MUCUJEPE CALLE PRINCIPAL', '1996-10-17', 1, 2, 1, 1, 1, 'NO', 1),
('A20E28C51', '16317737', '24453445', 'ALEXANDER', '', 'ROJAS', 'CABALLERO', 'MASCULINO', 'AV O DE OCTUBRE BARRIO SAN MIGUEL', '2003-06-10', 1, 2, 1, 1, 1, 'NO', 1),
('A2146E2E7', '18765432', '21456789', 'DIGMAR', '', 'PAREDES', '', 'FEMENINO', 'SANTA CRUZ DE MORA', '2005-12-21', 1, 2, 1, 1, 1, 'NO', 1),
('A412A2046', '16317737', '29587496', 'MARIA', 'JOSE', 'CONTRERAS', 'MARQUEZ', 'FEMENINO', 'EL VIGIA ESTADO MERIDA', '2000-10-17', 1, 2, 1, 1, 1, 'NO', 1),
('A4DEC5D92', '18765432', '25678354', 'LUIS', 'FERNANDO', 'VALENZUELA', 'GUTIERREZ', 'MASCULINO', 'AV ACEITERA SN BARRIO DE JUNIO', '2007-06-11', 2, 2, 10, 1, 1, 'NO', 0),
('A59B5F192', '12876516', '18633189', 'RICHARD', 'JOSUE', 'CHIRINOS', 'BELLO', 'MASCULINO', 'MUCUJEPE CALLE PRINCIPAL', '2004-12-08', 2, 2, 10, 1, 1, 'MEDIA', 0),
('A81C20092', '14123456', '98981212', 'CARMEN', 'BOLIVIA', 'MONTENEGRO', 'NUÑEZ', 'FEMENINO', 'BARRIO 1 DE DICIEMBRE AV. 4 DE PASAJE N. 855', '1994-07-26', 2, 2, 10, 1, 1, 'NO', 0),
('A9D8DBE61', '539576', '25654321', 'LENIN', 'JOSE', 'VIERA', 'RODRIGUEZ', 'MASCULINO', 'CABIMAS ESTADO ZULIA', '2002-09-24', 2, 2, 10, 1, 1, 'NO', 0),
('AB0D62A90', '16317737', '19876509', 'CARLITOS', '', 'VALENZUELA', 'VILLANUEVA', 'MASCULINO', 'AV ONCE DE OCTUBRE SN BARRIO NUEVO HORIZONTE', '1999-05-17', 2, 2, 13, 1, 1, 'NO', 0),
('ABC12462F', '10793241', '55667788', 'SIMÓN', '', 'IRIARTE', 'MUÑOZ', 'MASCULINO', 'BARRIO CENTRAL S/N', '1994-12-20', 3, 2, 13, 1, 1, 'NO', 0),
('AC65CB66B', '14123456', '897632', 'LIDIA', 'LUZ', 'MAMANI', 'QUISPE H', 'FEMENINO', 'AV. ACEITERA N. 673, S/N, BARRIO 1RO DE SEPTIEMBRE', '2009-08-04', 3, 2, 13, 1, 1, 'NO', 0),
('ACC809A2B', '33983532', '24984672', 'LEIDIMAR', 'JOSE', 'VIERA', 'RODRIGUEZ', 'FEMENINO', 'CABIMAS ESTADO ZULIA', '2003-04-15', 3, 2, 13, 1, 1, 'NO', 0),
('AD1B10315', '43232423', '12345555', 'RAMON', 'JOSE', 'GUTIERREZ', 'PEREZ', 'MASCULINO', 'SANTA CRUZ DE MORA ESTADO MERIDA', '1987-12-24', 4, 3, 16, 1, 1, 'NO', 0),
('AED430736', '12876516', '18633175', 'MOISES', 'RODOLFO', 'CHIRINOS', 'LEAL', 'MASCULINO', 'MUCUJEPE CALLE PRINCIPAL', '2003-11-30', 4, 3, 16, 1, 1, 'MEDIA', 0),
('AF2C9EFE5', '33983532', '5601253', 'DENIS', '', 'OHARA', 'ANTEZANA', 'MASCULINO', 'BARRIO ROSEDAL', '1986-05-12', 4, 3, 16, 1, 1, 'MEDIA', 0);
--
-- Estructura de tabla para la tabla `pagos`
--
CREATE TABLE `pagos` (
`codpago` int(11) NOT NULL,
`numcomprobante` varchar(25) CHARACTER SET utf8 COLLATE utf8_spanish_ci NOT NULL,
`codest` varchar(12) COLLATE utf8_unicode_ci NOT NULL,
`codnivel` int(11) NOT NULL,
`codgrado` int(11) NOT NULL,
`codturno` int(11) NOT NULL,
`codperiodo` int(11) NOT NULL,
`becado` varchar(10) CHARACTER SET utf8 COLLATE utf8_spanish_ci NOT NULL,
`mespago` varchar(2) COLLATE utf8_unicode_ci NOT NULL,
`montopago` float(8,2) NOT NULL,
`fechapago` date NOT NULL,
`statuspago` int(2) NOT NULL,
`codigo` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
--
-- Volcado de datos para la tabla `pagos`
--
INSERT INTO `pagos` (`codpago`, `numcomprobante`, `codest`, `codnivel`, `codgrado`, `codturno`, `codperiodo`, `becado`, `mespago`, `montopago`, `fechapago`, `statuspago`, `codigo`) VALUES
(1, 'C04B9BED4B8', 'A02409930', 2, 1, 1, 1, 'NO', '02', 200.00, '2017-07-17', 1, 1),
(2, 'C04B9BED4B8', 'A02409930', 2, 1, 1, 1, 'NO', '03', 200.00, '2017-07-17', 1, 1),
(3, 'C04B9BED4B8', 'A02409930', 2, 1, 1, 1, 'NO', '04', 200.00, '2017-07-17', 1, 1),
(4, 'C0BEF2B5BDB', 'A02409930', 2, 1, 1, 1, 'NO', '05', 200.00, '2017-07-17', 1, 1),
(5, 'C0BEF2B5BDB', 'A02409930', 2, 1, 1, 1, 'NO', '06', 200.00, '2017-07-17', 1, 1),
(6, 'C0BEF2B5BDB', 'A02409930', 2, 1, 1, 1, 'NO', '07', 200.00, '2017-07-17', 1, 1),
(7, 'C0BEF2B5BDB', 'A02409930', 2, 1, 1, 1, 'NO', '08', 200.00, '2017-07-17', 1, 1),
(8, 'C0BEF2B5BDB', 'A02409930', 2, 1, 1, 1, 'NO', '09', 200.00, '2017-07-17', 1, 1),
(9, 'C0BEF2B5BDB', 'A02409930', 2, 1, 1, 1, 'NO', '10', 200.00, '2017-07-17', 1, 1),
(10, 'C0BEF2B5BDB', 'A02409930', 2, 1, 1, 1, 'NO', '11', 200.00, '2017-07-17', 1, 1),
(11, 'CDAD7B785EB', 'A19EF297C', 2, 1, 1, 1, 'MEDIA', '02', 100.00, '2017-07-17', 1, 1),
(12, 'CDAD7B785EB', 'A19EF297C', 2, 1, 1, 1, 'MEDIA', '03', 100.00, '2017-07-17', 1, 1),
(13, 'CDAD7B785EB', 'A19EF297C', 2, 1, 1, 1, 'MEDIA', '04', 100.00, '2017-07-17', 1, 1),
(14, 'CDAD7B785EB', 'A19EF297C', 2, 1, 1, 1, 'MEDIA', '05', 100.00, '2017-07-17', 1, 1),
(15, '0', 'A19EF297C', 2, 1, 1, 1, 'MEDIA', '06', 100.00, '2017-07-17', 2, 1),
(16, '0', 'A19EF297C', 2, 1, 1, 1, 'MEDIA', '07', 100.00, '2017-07-17', 2, 1),
(17, '0', 'A19EF297C', 2, 1, 1, 1, 'MEDIA', '08', 100.00, '2017-07-17', 0, 1),
(18, '0', 'A19EF297C', 2, 1, 1, 1, 'MEDIA', '09', 100.00, '2017-07-17', 0, 1),
(19, '0', 'A19EF297C', 2, 1, 1, 1, 'MEDIA', '10', 100.00, '2017-07-17', 0, 1),
(20, '0', 'A19EF297C', 2, 1, 1, 1, 'MEDIA', '11', 100.00, '2017-07-17', 0, 1),
(21, 'C1CCB4AE893', 'A1A407ACA', 2, 1, 1, 1, 'NO', '02', 200.00, '2017-07-17', 1, 1),
(22, 'C1CCB4AE893', 'A1A407ACA', 2, 1, 1, 1, 'NO', '03', 200.00, '2017-07-17', 1, 1),
(23, 'C1CCB4AE893', 'A1A407ACA', 2, 1, 1, 1, 'NO', '04', 200.00, '2017-07-17', 1, 1),
(24, 'CEF5B766D13', 'A1A407ACA', 2, 1, 1, 1, 'NO', '05', 200.00, '2017-07-18', 1, 1),
(25, 'CEF5B766D13', 'A1A407ACA', 2, 1, 1, 1, 'NO', '06', 200.00, '2017-07-18', 1, 1),
(26, 'CEF5B766D13', 'A1A407ACA', 2, 1, 1, 1, 'NO', '07', 200.00, '2017-07-18', 1, 1),
(27, '0', 'A1A407ACA', 2, 1, 1, 1, 'NO', '08', 200.00, '2017-07-17', 0, 1),
(28, '0', 'A1A407ACA', 2, 1, 1, 1, 'NO', '09', 200.00, '2017-07-17', 0, 1),
(29, '0', 'A1A407ACA', 2, 1, 1, 1, 'NO', '10', 200.00, '2017-07-17', 0, 1),
(30, '0', 'A1A407ACA', 2, 1, 1, 1, 'NO', '11', 200.00, '2017-07-17', 0, 1),
(31, 'C77567D1AE6', 'A20E28C51', 2, 1, 1, 1, 'NO', '02', 200.00, '2017-07-17', 1, 1),
(32, 'C77567D1AE6', 'A20E28C51', 2, 1, 1, 1, 'NO', '03', 200.00, '2017-07-17', 1, 1),
(33, 'C77567D1AE6', 'A20E28C51', 2, 1, 1, 1, 'NO', '04', 200.00, '2017-07-17', 1, 1),
(34, '0', 'A20E28C51', 2, 1, 1, 1, 'NO', '05', 200.00, '2017-07-17', 2, 1),
(35, '0', 'A20E28C51', 2, 1, 1, 1, 'NO', '06', 200.00, '2017-07-17', 2, 1),
(36, '0', 'A20E28C51', 2, 1, 1, 1, 'NO', '07', 200.00, '2017-07-17', 2, 1),
(37, '0', 'A20E28C51', 2, 1, 1, 1, 'NO', '08', 200.00, '2017-07-17', 0, 1),
(38, '0', 'A20E28C51', 2, 1, 1, 1, 'NO', '09', 200.00, '2017-07-17', 0, 1),
(39, '0', 'A20E28C51', 2, 1, 1, 1, 'NO', '10', 200.00, '2017-07-17', 0, 1),
(40, '0', 'A20E28C51', 2, 1, 1, 1, 'NO', '11', 200.00, '2017-07-17', 0, 1),
(41, 'C41FC293F4C', 'A2146E2E7', 2, 1, 1, 1, 'NO', '02', 200.00, '2017-07-17', 1, 1),
(42, 'C41FC293F4C', 'A2146E2E7', 2, 1, 1, 1, 'NO', '03', 200.00, '2017-07-17', 1, 1),
(43, 'C41FC293F4C', 'A2146E2E7', 2, 1, 1, 1, 'NO', '04', 200.00, '2017-07-17', 1, 1),
(44, 'C41FC293F4C', 'A2146E2E7', 2, 1, 1, 1, 'NO', '05', 200.00, '2017-07-17', 1, 1),
(45, 'C41FC293F4C', 'A2146E2E7', 2, 1, 1, 1, 'NO', '06', 200.00, '2017-07-17', 1, 1),
(46, 'C41FC293F4C', 'A2146E2E7', 2, 1, 1, 1, 'NO', '07', 200.00, '2017-07-17', 1, 1),
(47, 'C41FC293F4C', 'A2146E2E7', 2, 1, 1, 1, 'NO', '08', 200.00, '2017-07-17', 1, 1),
(48, '0', 'A2146E2E7', 2, 1, 1, 1, 'NO', '09', 200.00, '2017-07-17', 0, 1),
(49, '0', 'A2146E2E7', 2, 1, 1, 1, 'NO', '10', 200.00, '2017-07-17', 0, 1),
(50, '0', 'A2146E2E7', 2, 1, 1, 1, 'NO', '11', 200.00, '2017-07-17', 0, 1),
(51, 'CA9E3D93782', 'A412A2046', 2, 1, 1, 1, 'NO', '02', 200.00, '2017-07-17', 1, 1),
(52, 'CA9E3D93782', 'A412A2046', 2, 1, 1, 1, 'NO', '03', 200.00, '2017-07-17', 1, 1),
(53, 'CA9E3D93782', 'A412A2046', 2, 1, 1, 1, 'NO', '04', 200.00, '2017-07-17', 1, 1),
(54, 'CA9E3D93782', 'A412A2046', 2, 1, 1, 1, 'NO', '05', 200.00, '2017-07-17', 1, 1),
(55, 'CA9E3D93782', 'A412A2046', 2, 1, 1, 1, 'NO', '06', 200.00, '2017-07-17', 1, 1),
(56, '0', 'A412A2046', 2, 1, 1, 1, 'NO', '07', 200.00, '2017-07-17', 2, 1),
(57, '0', 'A412A2046', 2, 1, 1, 1, 'NO', '08', 200.00, '2017-07-17', 0, 1),
(58, '0', 'A412A2046', 2, 1, 1, 1, 'NO', '09', 200.00, '2017-07-17', 0, 1),
(59, '0', 'A412A2046', 2, 1, 1, 1, 'NO', '10', 200.00, '2017-07-17', 0, 1),
(60, '0', 'A412A2046', 2, 1, 1, 1, 'NO', '11', 200.00, '2017-07-17', 0, 1); |