select * from (select xm,je from table) a , (select xm01,je01 from table) b
where a.xm = b.xm01
and a.je <> b.je01
<> 或 !=
转载于:https://www.cnblogs.com/leonlee/p/6178646.html
select * from (select xm,je from table) a , (select xm01,je01 from table) b
where a.xm = b.xm01
and a.je <> b.je01
<> 或 !=
转载于:https://www.cnblogs.com/leonlee/p/6178646.html