摘要： --不存在的记录删掉delete a from ECOrganizationPositionRelation a left join @ECOrganizationPositionRelation bon a.OrganPostionID=b.OrganizationID and a.PositionID=b.PositionIDwhere not exists(select * from ECOrganizationPositionRelation where OrganizationID=b.OrganizationID and PositionID=b.PositionID)--存在的. 阅读全文