在一张表中查找另一张表中没有的数据

[李超]

有两张表table1,table2; table2中的name字段是由table1中的NAME字段选择插入的，现在想选出table2.NAME中存在但table1.name中没有的字符，该怎么操作？

[obuntu]

not exist

相关子查询。。

[hokor]

select name from table2
except
select name from table1

[benzzy]

select * from table2 where name not in (select name from table1)

[Mr_Nice]

try

--1
SELECT A.*
FROM table2 A
WHERE NAME NOT IN (SELECT NAME FROM table1 B WHERE B.NAME = A.name)

--2
SELECT A.*
FROM table2 A
WHERE NOT EXISTS(SELECT 1 FROM table1 B WHERE A.NAME =B.name)

[黄_瓜]

select name from table2
except
select name from table1