Respuesta: obtener la fecha mas reciente Gracias scooby151 por responder tan pronto, pero lamentablemente no me da resultado tu modificacion, agrego un poco de datos para hacer el ejercicio a quien se tome la molestia:
Código MySQL:
Ver originalSET FOREIGN_KEY_CHECKS =0; -- ---------------------------- -- Table structure for vehiculos -- ---------------------------- -- ---------------------------- -- Records -- ----------------------------
Código MySQL:
Ver originalSET FOREIGN_KEY_CHECKS =0; -- ---------------------------- -- Table structure for neumaticos_inventario -- ---------------------------- -- ---------------------------- -- Records -- ---------------------------- INSERT INTO `neumaticos_inventario` VALUES ('1', '3251', '15.0', '15.0', '15.0', '99120'); INSERT INTO `neumaticos_inventario` VALUES ('2', '3250', '15.0', '15.0', '15.0', '99120'); INSERT INTO `neumaticos_inventario` VALUES ('3', '3236', '15.0', '15.0', '15.0', '105438'); INSERT INTO `neumaticos_inventario` VALUES ('4', '3287', '15.0', '15.0', '15.0', '105438'); INSERT INTO `neumaticos_inventario` VALUES ('5', '3333', '15.0', '15.0', '15.0', '101000'); INSERT INTO `neumaticos_inventario` VALUES ('6', '3332', '15.0', '15.0', '15.0', '105438');
Código MySQL:
Ver originalSET FOREIGN_KEY_CHECKS =0; -- ---------------------------- -- Table structure for neumaticos_vehiculos -- ---------------------------- UNIQUE KEY `id_pos_veh` (`posicion`,`id_vehiculo`), KEY `id_vehiculo_idx` (`id_vehiculo`), -- ---------------------------- -- Records -- ----------------------------
Código MySQL:
Ver originalSET FOREIGN_KEY_CHECKS =0; -- ---------------------------- -- Table structure for neumaticos_historial -- ---------------------------- KEY `id_vehiculo_idx` (`id_vehiculo`), KEY `id_neumatico_idx` (`id_neumatico`), -- ---------------------------- -- Records -- ---------------------------- INSERT INTO `neumaticos_historial` VALUES ('1', '13', '10000', '2011-01-01', '1', '1', '15.0', '15.0', '15.0', 'cambio_entrante'); INSERT INTO `neumaticos_historial` VALUES ('2', '13', '20000', '2011-02-01', '1', '1', '14.0', '14.0', '14.0', 'cambio_saliente'); INSERT INTO `neumaticos_historial` VALUES ('3', '10', '40000', '2011-03-01', '3', '1', '14.0', '14.0', '14.0', 'cambio_entrante'); INSERT INTO `neumaticos_historial` VALUES ('4', '10', '70000', '2011-04-01', '3', '1', '10.0', '10.0', '10.0', 'cambio_saliente'); INSERT INTO `neumaticos_historial` VALUES ('5', '95', '50000', '2011-05-01', '1', '1', '10.0', '10.0', '10.0', 'cambio_entrante'); INSERT INTO `neumaticos_historial` VALUES ('6', '13', '12000', '2011-01-10', '2', '2', '15.0', '15.0', '15.0', 'cambio_entrante'); INSERT INTO `neumaticos_historial` VALUES ('7', '13', '20000', '2011-02-01', '2', '2', '14.0', '14.0', '14.0', 'cambio_saliente'); INSERT INTO `neumaticos_historial` VALUES ('8', '12', '40000', '2011-03-11', '4', '2', '14.0', '14.0', '13.0', 'cambio_entrante'); INSERT INTO `neumaticos_historial` VALUES ('9', '12', '50000', '2011-04-11', '4', '2', '11.0', '11.0', '12.0', 'cambio_saliente'); INSERT INTO `neumaticos_historial` VALUES ('10', '95', '50000', '2011-05-01', '2', '2', '11.0', '11.0', '12.0', 'cambio_entrante'); INSERT INTO `neumaticos_historial` VALUES ('11', '13', '10000', '2011-01-01', '3', '3', '15.0', '15.0', '15.0', 'cambio_entrante'); INSERT INTO `neumaticos_historial` VALUES ('12', '13', '20000', '2011-02-01', '3', '3', '14.0', '14.0', '14.0', 'cambio_saliente'); INSERT INTO `neumaticos_historial` VALUES ('13', '95', '50000', '2011-05-01', '3', '3', '14.0', '14.0', '14.0', 'cambio_entrante'); INSERT INTO `neumaticos_historial` VALUES ('14', '13', '10000', '2011-01-01', '4', '4', '15.0', '15.0', '15.0', 'cambio_entrante'); INSERT INTO `neumaticos_historial` VALUES ('15', '13', '20000', '2011-02-01', '4', '4', '13.0', '13.0', '13.0', 'cambio_saliente'); INSERT INTO `neumaticos_historial` VALUES ('16', '95', '50000', '2011-05-01', '4', '4', '13.0', '13.0', '13.0', 'cambio_entrante'); INSERT INTO `neumaticos_historial` VALUES ('17', '95', '50000', '2011-05-01', '4', '4', '15.0', '15.0', '15.0', 'cambio_entrante'); INSERT INTO `neumaticos_historial` VALUES ('18', '95', '50000', '2011-05-01', '5', '5', '15.0', '15.0', '15.0', 'cambio_entrante'); INSERT INTO `neumaticos_historial` VALUES ('19', '95', '50000', '2011-05-01', '6', '6', '15.0', '15.0', '15.0', 'cambio_entrante');
|