select email from Email_Table t1 where not exists (select email from Contacted_table t2 where t1.email = t2.email)
或者
select email from Email_Table t1 where email not in (select email from Contacted_table)
select email from Email_Table t1 where not exists (select email from Contacted_table t2 where t1.email = t2.email)
或者
select email from Email_Table t1 where email not in (select email from Contacted_table)
名师互学网 版权所有 (c)2021-2022 ICP备案号：晋ICP备2021003244-6号
