CREATE 
    ALGORITHM = UNDEFINED 
    DEFINER = `root`@`localhost` 
    SQL SECURITY DEFINER
VIEW `dbrecoleccion`.`persona_servicio` AS
    SELECT 
        `a`.`idpersona` AS `idpersona`,
        `a`.`nombres` AS `nombres`,
        `a`.`apaterno` AS `apaterno`,
        `a`.`amaterno` AS `amaterno`,
        `a`.`documento` AS `documento`,
        `a`.`sexo` AS `sexo`,
        `a`.`telefono` AS `telefono`,
        `a`.`zona` AS `zona`,
        `b`.`idservicios` AS `idservicios`,
        `b`.`codigo` AS `codigo`,
        `b`.`numromeses` AS `numromeses`,
        `b`.`idtipo_servicios` AS `idtipo_servicios`,
        `b`.`estado` AS `estado`,
        `b`.`fecha` AS `fecha`
    FROM
        (`dbrecoleccion`.`persona` `a`
        JOIN `dbrecoleccion`.`servicios` `b` ON ((`a`.`idpersona` = `b`.`idpersona`)))