c*****t 发帖数: 1879 | 1 I obtain table from peer 1 and table from peer 2.
Both peers may have identical rows and both may have different rows.
What is the sql command to merge the two table?
For ex
Peer1:
Name
abc
def
deg
Now add Peer 2 table:
Name
aaa
dddd
def
Can someone show me? Thanks |
F***a 发帖数: 525 | 2 you can do it using full outer join
【在 c*****t 的大作中提到】 : I obtain table from peer 1 and table from peer 2. : Both peers may have identical rows and both may have different rows. : What is the sql command to merge the two table? : For ex : Peer1: : Name : abc : def : deg : Now add Peer 2 table:
|
F***a 发帖数: 525 | 3 select * from peer1 full outer join peer2 on peer1.name = peer2.name
【在 F***a 的大作中提到】 : you can do it using full outer join
|
b***s 发帖数: 14 | 4 This is a data integration problem. Is there any "value correspondence"
between attributes with different names in the two tables?
Google "clio IBM Toronto" for the schema translation project done at
IBM and Toronto.
【在 c*****t 的大作中提到】 : I obtain table from peer 1 and table from peer 2. : Both peers may have identical rows and both may have different rows. : What is the sql command to merge the two table? : For ex : Peer1: : Name : abc : def : deg : Now add Peer 2 table:
|