tengo estas tablas
las tablas cilindro y esfera ylentes ya están pobladas con sus datos.
la tabla rx debería contener una serie de combinaciones que por ejemplo para un lentes.id_lente está solucionado con una consulta un tanto .......
es esta
Código MySQL:
Ver original `c`.
`ID_cil` AS `id_cil`, `c`.
`cilindro` AS `cilindro`, `e`.
`ID_esf` AS `id_esf`, (`cilindro` `c`
`c`.
`ID_cil` AS `id_cil`, `c`.
`cilindro` AS `cilindro`, `e`.
`ID_esf` AS `id_esf`, (`cilindro` `c`
((`c`.`cilindro` = 0)
`c`.
`ID_cil` AS `id_cil`, `c`.
`cilindro` AS `cilindro`, `e`.
`ID_esf` AS `id_esf`, (`cilindro` `c`
((`c`.`cilindro` = -(0.25))
`c`.
`ID_cil` AS `id_cil`, `c`.
`cilindro` AS `cilindro`, `e`.
`ID_esf` AS `id_esf`, (`cilindro` `c`
((`c`.`cilindro` = -(0.50))
`c`.
`ID_cil` AS `id_cil`, `c`.
`cilindro` AS `cilindro`, `e`.
`ID_esf` AS `id_esf`, (`cilindro` `c`
((`c`.`cilindro` = -(0.75))
`c`.
`ID_cil` AS `id_cil`, `c`.
`cilindro` AS `cilindro`, `e`.
`ID_esf` AS `id_esf`, (`cilindro` `c`
((`c`.`cilindro` = -(1.00))
`c`.
`ID_cil` AS `id_cil`, `c`.
`cilindro` AS `cilindro`, `e`.
`ID_esf` AS `id_esf`, (`cilindro` `c`
((`c`.`cilindro` = -(1.25))
`c`.
`ID_cil` AS `id_cil`, `c`.
`cilindro` AS `cilindro`, `e`.
`ID_esf` AS `id_esf`, (`cilindro` `c`
((`c`.`cilindro` = -(1.50))
`c`.
`ID_cil` AS `id_cil`, `c`.
`cilindro` AS `cilindro`, `e`.
`ID_esf` AS `id_esf`, (`cilindro` `c`
((`c`.`cilindro` = -(1.75))
`c`.
`ID_cil` AS `id_cil`, `c`.
`cilindro` AS `cilindro`, `e`.
`ID_esf` AS `id_esf`, (`cilindro` `c`
((`c`.`cilindro` = 0.00)
`c`.
`ID_cil` AS `id_cil`, `c`.
`cilindro` AS `cilindro`, `e`.
`ID_esf` AS `id_esf`, (`cilindro` `c`
((`c`.`cilindro` = -(0.25))
`c`.
`ID_cil` AS `id_cil`, `c`.
`cilindro` AS `cilindro`, `e`.
`ID_esf` AS `id_esf`, (`cilindro` `c`
((`c`.`cilindro` = -(0.50))
`c`.
`ID_cil` AS `id_cil`, `c`.
`cilindro` AS `cilindro`, `e`.
`ID_esf` AS `id_esf`, (`cilindro` `c`
((`c`.`cilindro` = -(0.75))
`c`.
`ID_cil` AS `id_cil`, `c`.
`cilindro` AS `cilindro`, `e`.
`ID_esf` AS `id_esf`, (`cilindro` `c`
((`c`.`cilindro` = -(1.00))
`c`.
`ID_cil` AS `id_cil`, `c`.
`cilindro` AS `cilindro`, `e`.
`ID_esf` AS `id_esf`, (`cilindro` `c`
((`c`.`cilindro` = -(1.25))
`c`.
`ID_cil` AS `id_cil`, `c`.
`cilindro` AS `cilindro`, `e`.
`ID_esf` AS `id_esf`, (`cilindro` `c`
((`c`.`cilindro` = -(1.50))
`c`.
`ID_cil` AS `id_cil`, `c`.
`cilindro` AS `cilindro`, `e`.
`ID_esf` AS `id_esf`, (`cilindro` `c`
((`c`.`cilindro` = -(1.75))
el caso es que funciona y me da el resultado requerido.
ahora la pregunta es si de la salida de esta consultapuedo poblar la tabla rx automaticamente??
gracias de antemano.