<pre name="code" class="html">mysql not in 查询某个字段的值不包含在另一个表的相应字段的所有值里
<span style="font-family: Arial, Helvetica, sans-serif; background-color: rgb(255, 255, 255);"></span><pre name="code" class="html"> selectui.id,ui.erpName
from user_info ui
where ui.erpName not in(select erpName from organization)