不了解你是不是一定要写成right join，但是我觉得用Not exists写起来好像更容易懂，也好写，你参考看看select * from table1 a where not exists (select 1 from (select '520202198308066711' as nsrbh union select '520202198308066712' as nsrbh union select '520202198308066713' as nsrbh from dual) b where a.nsrbh=b.nsrbh)...
