请教SQL 问题！

[hcyzs]

请问：在两个表中都有id和name字段，欲显示出
不同(id或name内容不同)的记录，如何用SQL语言
表达？本人用select table1.id,table1.name from
table1,table2 where table1.id<>table2.id and
table1.name<>table2.name语句无法做到。

[jiangbo]

select dist table1.id,table1.name from table1 union select dist table2.id,table2.name from table2 into cursor n1

select dist * from n1

[HjmaAsC]

如果你想找table1的不同数据
SELECT a1.id, a1.name
FROM table1 a1, table2 a2
WHERE a1.id <> a2.id
UNION
SELECT a1.id, a1.name
FROM table1 a1
WHERE a1.name <> a2.name

如果你想找table2的不同数据则用相反的方法即可.
你也可以把它们全部都用UNION联合起来也可以。

[WTQ]

select table1.id,table1.name from table1
where not exists (select * from table2 where table1.id+table1.name = table2.id + table2.name)
union
select table2.id,table2.name from table2
where not exists (select * from table1 where table1.id+table1.name = table2.id + table2.name)

[sintony]

你不觉的你的SQL语句中该是OR尔不该是AND吗？

[feng]

sintony说的对。

[WHQ]

是这种效果吗？
SELECT id, name from Table1, Table2
WHERE (Table1.id = Table2.id AND Table1.name <> Table2.name)
OR (Table1.name = Table2.name AND Table1.id <> Table2.id)

[july]

你的语句是ID和NAME均不相同
select table1.id,table1.name from
table1,table2 where table1.id<>table2.id or
table1.name<>table2.name

[LaoZheng]

SELECT id,name
FROM table1 where id not in( select id from table2)
UNION
SELECT id,name
FROM table1 where name not in( select name from table2)

[Daisy]

具体的SQL，在这写不出，但我有其他办法。你可以将在ACCESS中建两同样的表，在ACCESS中有一个创建“无法匹配数据的QUERY”的向导，你用它创建好这个向导。打开此QUERY，到VIEW->SQL VIEW中便会看到它产生的SQL 代码了。

[solomon]

SELECT id,name
FROM table1 where (id,name) not in( select id, name from table2)
UNION
SELECT id,name
FROM table2 where (Id, name) not in( select id, name from table1)

[july]

use temp table