功能:查询A表中字段v与B表中字段m不重复的记录并去除重复 sql语句: select distinct v from A where not exists(select DISTINCT m from B where A.v=B.m) 表A: 表B: