问一个简单的sql语句谢谢(30分)

G

gordon2003

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2006-07-13

• #1

两个数据表对比查出不同之处语句怎样写谢谢比如
sheet1$
name id
1 1
2 2
3 3
4 4
5 5

sheet2$
name id
1 1
2 2
3 3
4 4
5 5
6 6
最后查找几果

name id
6 6

 

H

happycyp

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2006-07-13

• #2

select * from b2 where name not in (select name from b1);

 

J

jiang5460

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2006-07-13

• #3

Select * from B2 where exists (select * from B1 where B1.nae<>b2.name and b1.id<>b2.id)

 

E

eggvstone

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2006-07-13

• #4

select * from(
select * from Table1
union
select * from Table2
) as TempUnion
where ID not in(select Table1.ID from Table1, Table2 where Table1.ID=Table2.ID and Table1.Name=Table2.Name)

不知道合不合你要求，应该可以筛选所有TABLE1和TABLE2中不一样的数据。

 

李

李翔鹏

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2006-07-13

• #5

Select * from B2 where exists (select * from B1 where B1.nae<>b2.name and b1.id<>b2.id)

 

A

abraveboy

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2006-07-13

• #6

select * from b2 where name not in(select name from b1.name<>b2.name and b1.id<>b2.id)

 

L

lifangchao2008

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2006-07-13

• #7

select * from biao2 where name not in (select name from biao1);[8D]

 

B

bytelife

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2006-07-13

• #8

试试下面的SQL语句,绝对可以得出你想要的结果
select name,id from
(select name,id from sheet1
union all
select name,id from sheet2) a
group by name,id having count(*)=1

这个语句的想法是这样的:
先将2个表的内容UNION到一个表,然后按NAME,ID分组,count(*)>1的即为重复的值.

 

漂

漂流的雲

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2006-07-13

• #9

SELECT * FROM sheet2$ where name not in (select * from sheet1$ where sheet1$.name<>sheet2$.name and sheet1$.ID<>sheet2$.ID)

 

T

testmens

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2006-07-13

• #10

seletct * from sheet1$ where name not in(select name from sheet1$ as s1 inner join sheet2$ as s2) union seletct * from sheet2$ where name not in(select name from sheet1$ as s1 inner join sheet2$ as s2)

 

G

gordon2003

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2006-07-14

• #11

多人接受答案了。