Hi
Create table TableA(codeA I, CodeB I, CodeC I)
insert into TableA(codeA, codeB, codeC) values( 1,2,3)
insert into TableA(codeA, codeB, codeC) values( 1,3,4)
insert into TableA(codeA, codeB, codeC) values( 2,2,1)
insert into TableA(codeA, codeB, codeC) values( 2,2,3)
insert into TableA(codeA, codeB, codeC) values( 3,3,3)
-----
Create table TableB(codeA I, CodeB I, CodeD I)
insert into TableA(codeA, codeB, codeD) values( 1,2,3)
insert into TableA(codeA, codeB, codeD) values( 1,3,4)
insert into TableA(codeA, codeB, codeD) values( 2,6,1)
insert into TableA(codeA, codeB, codeD) values( 4,2,3)
insert into TableA(codeA, codeB, codeD) values( 4,3,3)
--------
Create table TableD(codeA I, CodeB I, CodeE I)
insert into TableA(codeA, codeB, codeE) values( 1,1,3)
insert into TableA(codeA, codeB, codeE) values( 1,3,4)
insert into TableA(codeA, codeB, codeE) values( 2,4,1)
insert into TableA(codeA, codeB, codeE) values( 2,2,3)
insert into TableA(codeA, codeB, codeE) values( 3,5,3)
-------Result set
codeA codeB codeC codeD codeE
1 1 3
1 2 3
1 3 4 4 4
2 2 4 3
2 4 1
2 6 1
3 3 3
3 5 3
4 2 3
4 3 3
TIA, E.
No virus found in this outgoing message.
Checked by AVG.
Version: 7.5.524 / Virus Database: 269.23.6/1403 - Release Date: 29-Apr-08
07:26
©2008 Eurico Chagas Filho |
|
