Question

SQL查询两个表相同的两个字段里不同的数据有哪些

我的SQL数据库里有两张表里面有相同的两个列：
TABLE1 TABLE2
xingming xingming
张三 张三
李四 李四
王五 刘六
赵二 王五
马七
我怎么通过SQL语句查询出“赵二”“马七”和“刘六”呢？

Answer 1

SELECT xingming FROM TABLE1 WHERE NOT EXISTS (SELECT xingming FROM TABLE2 WHERE xingming = TABLE1.xingming)
UNION
SELECT xingming FROM TABLE2 WHERE NOT EXISTS (SELECT xingming FROM TABLE1 WHERE xingming = TABLE2.xingming)

Answer 2

SELECT xingming FROM TABLE1 WHERE NOT EXISTS (SELECT 1 FROM TABLE2 WHERE xingming = TABLE1.xingming)
UNION
SELECT xingming FROM TABLE2 WHERE NOT EXISTS (SELECT 1 FROM TABLE1 WHERE xingming = TABLE2.xingming)

Answer 3

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

Answer 4

select xingming from table1 where xingming='赵二'
select xingming from table1 where xingming='马七'
select xingming from table2 where xingming='刘六'