About views...

[expired user #8132]'s profile image [expired user #8132] posted 10 years ago in General Permalink
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?
[expired user #8169]'s profile image [expired user #8169] posted 10 years ago Permalink
I have same problem.

First i thought it was an issue with my backup from server to server ( different server mysql/maria).
but if someone else have this problem, maybe it's not me ^^

Please login to leave a reply, or register at first.