Question 3: merging data, getting rid of dup? - 未名空间MITBBS历史存档

国际科技财经博客移民网络热点娱乐民生时事公众号

Redian新闻

>未名空间

>Database - 数据库

Question 3: merging data, getting rid of dup?

Question 3: merging data, getting rid of dup?# Database - 数据库

c*t2003-03-13 08:03

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*a2003-03-13 08:03

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*a2003-03-13 08:03

3 楼

select * from peer1 full outer join peer2 on peer1.name = peer2.name

【在 F***a 的大作中提到】

: you can do it using full outer join

b*s2003-03-13 08:03

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 的大作中提到】