SQL 一条记录的的两个字段值相同与不同的查询

select * from (select xm,je from table) a , (select xm01,je01 from table) b
where a.xm = b.xm01
and a.je <> b.je01

<> 或 !=

原文：http://www.cnblogs.com/leonlee/p/6178646.html