When I make a view like this one:
SELECT 0_clientes.*,
cliente_correo.correo,
cliente_telefono_fijo.fijo,
cliente_telefono_movil.movil,
cliente_web.direccion_web
FROM 0_clientes,
cliente_correo,
cliente_telefono_fijo,
cliente_telefono_movil,
cliente_web
WHERE 0_clientes.CIF=cliente_correo.CIF
AND cliente_correo.CIF=cliente_telefono_fijo.CIF
AND cliente_telefono_fijo.CIF=cliente_telefono_movil.CIF
AND cliente_telefono_movil.CIF=cliente_web.CIF;
And save, it is saved like this:
select `0_clientes`.`Tratamiento` AS Tratamiento`,`0_clientes`.`Nombre` AS `Nombre`,`0_clientes`.`Apellido1` AS `Apellido1`,`0_clientes`.`Apellido 2` AS `Apellido 2`,`0_clientes`.`CIF` AS `CIF`,`0_clientes`.`Empresa` AS `Empresa`,`0_clientes`.`Fecha_nacimiento` AS `Fecha_nacimiento`,`cliente_correo`.`correo` AS `correo`,`cliente_telefono_fijo`.`fijo` AS `fijo`,`cliente_telefono_movil`.`movil` AS `movil`,`cliente_web`.`direccion_web` AS `direccion_web` from ((((`0_clientes` join `cliente_correo`) join `cliente_telefono_fijo`) join `cliente_telefono_movil`) join `cliente_web`) where ((`0_clientes`.`CIF` = `cliente_correo`.`CIF`) and (`cliente_correo`.`CIF` = `cliente_telefono_fijo`.`CIF`) and (`cliente_telefono_fijo`.`CIF` = `cliente_telefono_movil`.`CIF`) and (`cliente_telefono_movil`.`CIF` = `cliente_web`.`CIF`))
In older versions the views were saved without changes so I supose I'm doing something wrong, How is possible to save views without changes?
About views...
Please login to leave a reply, or register at first.