select name from table2 except select name from table1
select * from table2 where name not in (select name from table1)
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
except
select name from table1
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)
except
select name from table1