Drop Table TTCA ;
Create Table TTCA (
FechaHora Varchar (16) Not Null,
Presion1 Varchar (10) Not Null,
Presion2 Varchar (10) Not Null,
Primary Key( FechaHora ) );
Drop Table TTCB ;
Create Table TTCB (
FechaHora Varchar (16) Not Null,
Presion2 Varchar (10) Not Null,
Primary Key( FechaHora ) );
Insert Into TTCA ( FechaHora, Presion1, Presion2 ) Values ( '20150612 091212', '07675', '');
Insert Into TTCA ( FechaHora, Presion1, Presion2 ) Values ( '20150612 091201', '08805', '');
Insert Into TTCA ( FechaHora, Presion1, Presion2 ) Values ( '20150612 091205', '09089', '');
Insert Into TTCA ( FechaHora, Presion1, Presion2 ) Values ( '20150612 101212', '11074', '');
Insert Into TTCA ( FechaHora, Presion1, Presion2 ) Values ( '20150612 110116', '12362', '');
Insert Into TTCA ( FechaHora, Presion1, Presion2 ) Values ( '20150612 110521', '09243', '');
Insert Into TTCA ( FechaHora, Presion1, Presion2 ) Values ( '20150612 121232', '16134', '');
Insert Into TTCA ( FechaHora, Presion1, Presion2 ) Values ( '20150612 131623', '27226', '');
Insert Into TTCA ( FechaHora, Presion1, Presion2 ) Values ( '20150612 152134', '18327', '');
Insert Into TTCA ( FechaHora, Presion1, Presion2 ) Values ( '20150612 153238', '09429', '');
Insert Into TTCA ( FechaHora, Presion1, Presion2 ) Values ( '20150612 162337', '16520', '');
Insert Into TTCA ( FechaHora, Presion1, Presion2 ) Values ( '20150612 163436', '24611', '');
Insert Into TTCB ( FechaHora, Presion2 ) Values ( '20150612 091212', '67567' );
Insert Into TTCB ( FechaHora, Presion2 ) Values ( '20150617 091201', '80580' ); -- X
Insert Into TTCB ( FechaHora, Presion2 ) Values ( '20150618 091205', '08908' ); -- X
Insert Into TTCB ( FechaHora, Presion2 ) Values ( '20150612 101212', '07407' );
Insert Into TTCB ( FechaHora, Presion2 ) Values ( '20150611 110116', '36236' ); -- X
Insert Into TTCB ( FechaHora, Presion2 ) Values ( '20150612 110521', '24324' );
Insert Into TTCB ( FechaHora, Presion2 ) Values ( '20150612 121232', '13413' );
Insert Into TTCB ( FechaHora, Presion2 ) Values ( '20150614 131623', '22622' ); -- X
Insert Into TTCB ( FechaHora, Presion2 ) Values ( '20150612 152134', '32732' );
Insert Into TTCB ( FechaHora, Presion2 ) Values ( '20150612 153238', '42942' );
Insert Into TTCB ( FechaHora, Presion2 ) Values ( '20150610 162337', '52052' ); -- X
Insert Into TTCB ( FechaHora, Presion2 ) Values ( '20150612 163436', '61161' );
Commit ;
Select FechaHora, Presion1, Presion2 FROM TTCA ;
Select FechaHora, Presion2 FROM TTCB ;
Update TTCA A,
TTCB B Set A.Presion2 = B.Presion2
Where A.FechaHora = B.FechaHora ;
Select FechaHora, ' ', Presion2 From TTCB
Where FechaHora NOT IN( Select Distinct FechaHora From TTCA ) ;
Insert Into TTCA ( FechaHora, Presion1, Presion2 )
Values ( Select FechaHora, ' ', Presion2
From TTCB
Where FechaHora NOT IN( Select Distinct FechaHora From TTCA ) ) ;
Select FechaHora, Presion1, Presion2 FROM TTCA;