create view [dbo].[consulta_info] as
select b.nom,b.cod,a.ip,fip,a.upi,a.fupi ,a.upr,a.fupr
from dnsreg a 
inner join nombre b on a.dns=b.dns


create view [dbo].[consulta_info_1] as
select 
b.nom as LOCAL,
b.cod AS NUMERO_LOCAL,
a.ip AS IP_LOCAL,
fip AS IP_FECHA_INFORMADA,
a.upi AS PAQUETE_NUMERO,
a.fupi AS PAQUETE_FECHA
from dnsreg a 
inner join nombre b on a.dns=b.dns

