Redian新闻
>
Question 3: merging data, getting rid of dup?
avatar
Question 3: merging data, getting rid of dup?# Database - 数据库
c*t
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
avatar
F*a
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:

avatar
F*a
3
select * from peer1 full outer join peer2 on peer1.name = peer2.name

【在 F***a 的大作中提到】
: you can do it using full outer join
avatar
b*s
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:

相关阅读
logo
联系我们隐私协议©2024 redian.news
Redian新闻
Redian.news刊载任何文章,不代表同意其说法或描述,仅为提供更多信息,也不构成任何建议。文章信息的合法性及真实性由其作者负责,与Redian.news及其运营公司无关。欢迎投稿,如发现稿件侵权,或作者不愿在本网发表文章,请版权拥有者通知本网处理。