poblar una tabla a partir de otras

[gralf]

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:

select 
        `c`.`ID_cil` AS `id_cil`,
        `c`.`cilindro` AS `cilindro`,
        `e`.`ID_esf` AS `id_esf`,
        `e`.`esfera` AS `esfera`
    from
        (`cilindro` `c`
        join `esfera` `e`)
    where
        ((`c`.`cilindro` between -(2.00) and 0.00)
            and (`e`.`esfera` between -(4.00) and 2.00)) 
    union (select 
        `c`.`ID_cil` AS `id_cil`,
        `c`.`cilindro` AS `cilindro`,
        `e`.`ID_esf` AS `id_esf`,
        `e`.`esfera` AS `esfera`
    from
        (`cilindro` `c`
        join `esfera` `e`)
    where
        ((`c`.`cilindro` = 0)
            and (`e`.`esfera` between 2.25 and 4.00))) union (select 
        `c`.`ID_cil` AS `id_cil`,
        `c`.`cilindro` AS `cilindro`,
        `e`.`ID_esf` AS `id_esf`,
        `e`.`esfera` AS `esfera`
    from
        (`cilindro` `c`
        join `esfera` `e`)
    where
        ((`c`.`cilindro` = -(0.25))
            and (`e`.`esfera` between 2.25 and 3.75))) union (select 
        `c`.`ID_cil` AS `id_cil`,
        `c`.`cilindro` AS `cilindro`,
        `e`.`ID_esf` AS `id_esf`,
        `e`.`esfera` AS `esfera`
    from
        (`cilindro` `c`
        join `esfera` `e`)
    where
        ((`c`.`cilindro` = -(0.50))
            and (`e`.`esfera` between 2.25 and 3.50))
    order by `e`.`esfera` , `c`.`cilindro`) union (select 
        `c`.`ID_cil` AS `id_cil`,
        `c`.`cilindro` AS `cilindro`,
        `e`.`ID_esf` AS `id_esf`,
        `e`.`esfera` AS `esfera`
    from
        (`cilindro` `c`
        join `esfera` `e`)
    where
        ((`c`.`cilindro` = -(0.75))
            and (`e`.`esfera` between 2.25 and 3.25))) union (select 
        `c`.`ID_cil` AS `id_cil`,
        `c`.`cilindro` AS `cilindro`,
        `e`.`ID_esf` AS `id_esf`,
        `e`.`esfera` AS `esfera`
    from
        (`cilindro` `c`
        join `esfera` `e`)
    where
        ((`c`.`cilindro` = -(1.00))
            and (`e`.`esfera` between 2.25 and 3.00))) union (select 
        `c`.`ID_cil` AS `id_cil`,
        `c`.`cilindro` AS `cilindro`,
        `e`.`ID_esf` AS `id_esf`,
        `e`.`esfera` AS `esfera`
    from
        (`cilindro` `c`
        join `esfera` `e`)
    where
        ((`c`.`cilindro` = -(1.25))
            and (`e`.`esfera` between 2.25 and 2.75))) union (select 
        `c`.`ID_cil` AS `id_cil`,
        `c`.`cilindro` AS `cilindro`,
        `e`.`ID_esf` AS `id_esf`,
        `e`.`esfera` AS `esfera`
    from
        (`cilindro` `c`
        join `esfera` `e`)
    where
        ((`c`.`cilindro` = -(1.50))
            and (`e`.`esfera` between 2.25 and 2.50))) union (select 
        `c`.`ID_cil` AS `id_cil`,
        `c`.`cilindro` AS `cilindro`,
        `e`.`ID_esf` AS `id_esf`,
        `e`.`esfera` AS `esfera`
    from
        (`cilindro` `c`
        join `esfera` `e`)
    where
        ((`c`.`cilindro` = -(1.75))
            and (`e`.`esfera` between 2.25 and 2.25))) union (select 
        `c`.`ID_cil` AS `id_cil`,
        `c`.`cilindro` AS `cilindro`,
        `e`.`ID_esf` AS `id_esf`,
        `e`.`esfera` AS `esfera`
    from
        (`cilindro` `c`
        join `esfera` `e`)
    where
        ((`c`.`cilindro` = 0.00)
            and (`e`.`esfera` between -(6.00) and -(4.00)))) union (select 
        `c`.`ID_cil` AS `id_cil`,
        `c`.`cilindro` AS `cilindro`,
        `e`.`ID_esf` AS `id_esf`,
        `e`.`esfera` AS `esfera`
    from
        (`cilindro` `c`
        join `esfera` `e`)
    where
        ((`c`.`cilindro` = -(0.25))
            and (`e`.`esfera` between -(5.75) and -(4.00)))) union (select 
        `c`.`ID_cil` AS `id_cil`,
        `c`.`cilindro` AS `cilindro`,
        `e`.`ID_esf` AS `id_esf`,
        `e`.`esfera` AS `esfera`
    from
        (`cilindro` `c`
        join `esfera` `e`)
    where
        ((`c`.`cilindro` = -(0.50))
            and (`e`.`esfera` between -(5.50) and -(4.00)))) union (select 
        `c`.`ID_cil` AS `id_cil`,
        `c`.`cilindro` AS `cilindro`,
        `e`.`ID_esf` AS `id_esf`,
        `e`.`esfera` AS `esfera`
    from
        (`cilindro` `c`
        join `esfera` `e`)
    where
        ((`c`.`cilindro` = -(0.75))
            and (`e`.`esfera` between -(5.25) and -(4.00)))) union (select 
        `c`.`ID_cil` AS `id_cil`,
        `c`.`cilindro` AS `cilindro`,
        `e`.`ID_esf` AS `id_esf`,
        `e`.`esfera` AS `esfera`
    from
        (`cilindro` `c`
        join `esfera` `e`)
    where
        ((`c`.`cilindro` = -(1.00))
            and (`e`.`esfera` between -(5.00) and -(4.00)))) union (select 
        `c`.`ID_cil` AS `id_cil`,
        `c`.`cilindro` AS `cilindro`,
        `e`.`ID_esf` AS `id_esf`,
        `e`.`esfera` AS `esfera`
    from
        (`cilindro` `c`
        join `esfera` `e`)
    where
        ((`c`.`cilindro` = -(1.25))
            and (`e`.`esfera` between -(4.75) and -(4.00)))) union (select 
        `c`.`ID_cil` AS `id_cil`,
        `c`.`cilindro` AS `cilindro`,
        `e`.`ID_esf` AS `id_esf`,
        `e`.`esfera` AS `esfera`
    from
        (`cilindro` `c`
        join `esfera` `e`)
    where
        ((`c`.`cilindro` = -(1.50))
            and (`e`.`esfera` between -(4.50) and -(4.00)))) union (select 
        `c`.`ID_cil` AS `id_cil`,
        `c`.`cilindro` AS `cilindro`,
        `e`.`ID_esf` AS `id_esf`,
        `e`.`esfera` AS `esfera`
    from
        (`cilindro` `c`
        join `esfera` `e`)
    where
        ((`c`.`cilindro` = -(1.75))
            and (`e`.`esfera` between -(4.25) and -(4.00))))
 

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.