SELECT clientes.dni,clientes.nombre,provincias.provincia,Clientes.cp,municipios.municipio,clientes.calle,clientes.numero,gestion.fecha,gestion.fecha1,gestion.juntas,gestion.texto
From clientes
INNER JOIN GESTION ON clientes.dni = gestion.dni
INNER JOIN MUNICIPIOS ON clientes.cp = municipios.cp
INNER JOIN PROVINCIAS ON clientes.idprov = provincias.idprov
Where clientes.dni= ‘15681942 R’
Create table Tabla_Al_Pedo (
dni Varchar(12) Not Null with Default ' ', -- Columna donde harias el Update
fecha Varchar(8) Not Null with Default ' ', -- Fecha del update
Primary Key( dni ) ) ;
Update Tabla_Al_Pedo Set dni = ‘15681942 R’,
fecha = to_char(date()) ;
commit work;
CREATE VIEW VLO_VI_EN_EL_FORO AS
SELECT C.dni AS DNI,
C.nombre AS NOMBRE,
P.provincia AS PROVINCIA,
C.cp AS CP,
M.municipio AS MUNICIPIO,
C.calle AS CALLE,
C.numero AS NUMERO,
G.fecha AS FECHA,
G.fecha1 AS FECHA1,
G.juntas AS JUNTAS,
G.texto AS TEXTO
From clentes C ,
provincias P ,
municipios M ,
gestion G
Where C.dni = G.dni
And C.cp = M.cp
And C.idprov = P.idprov
And C.dni = (SELECT dni FROM Tabla_Al_Pedo);
CREATE VIEW VLO_VI_EN_EL_FORO AS
SELECT C.dni AS DNI,
C.nombre AS NOMBRE,
P.provincia AS PROVINCIA,
C.cp AS CP,
M.municipio AS MUNICIPIO,
C.calle AS CALLE,
C.numero AS NUMERO,
G.fecha AS FECHA,
G.fecha1 AS FECHA1,
G.juntas AS JUNTAS,
G.texto AS TEXTO
From clentes C ,
provincias P ,
municipios M ,
gestion G ,
Tabla_Al_Pedo T
Where C.dni = G.dni
And C.cp = M.cp
And C.idprov = P.idprov
And C.dni = T.dni ;
And G.dni = T.dni ;