Jul
1
根据条件查询相同字段的记录，看其简单的问题，突然写出来，还真有点麻烦：相同字段是same_zhoz，查询表zhoz_dat。ＳＱＬ文如下：
select a.* from zhoz_dat a join zhoz_dat b on (a.id<>b.id and a.school_id=b.school_id and b.same_zhoz = 0 and a.same_zhoz = 0 and a.delete_flg=0 and b.delete_flg=0)
