--查询不匹配的人员SELECTH.id,H.LASTNAME,H.DEPARTMENTIDFROMcus_fielddatacINNERJOINhrmresourceHONH.id=c.idLEFTJOINview_bmcjpathvONh.departmentid=v.idWHEREH.STATUS<5ANDc.scopeid=-1AND(c.field26<>v.field1OR c.field27&