试试这个
SELECT xsStudent.UnitiveId AS 学生编号, xsStudent.StudentName as 学生姓名, DictSex.Content as 性别, DictResidentType.Content AS 户口类别, DictStudyStatus.Content AS 学籍状态,xsStudent.UnitiveId,'0101010001000000'
FROM xsStudent LEFT OUTER JOIN DictSex ON DictSex.Code = xsStudent.Sex LEFT OUTER JOIN DictStudyStatus ON xsStudent.StudyStatus = DictStudyStatus.Code LEFT OUTER JOIN DictResidentType ON DictResidentType.Code = xsStudent.RegisterType
where UnitiveId like '%2001______' and UnitiveId like '0101010001%' and RegionCode != 'aa' and (HomePhone != '11' or HomePhone != '22') and (StudentName!= 'cc' or StudentName!= 'dd' )
SELECT xsStudent.UnitiveId AS 学生编号, xsStudent.StudentName as 学生姓名, DictSex.Content as 性别, DictResidentType.Content AS 户口类别, DictStudyStatus.Content AS 学籍状态,xsStudent.UnitiveId,'0101010001000000'
FROM xsStudent LEFT OUTER JOIN DictSex ON DictSex.Code = xsStudent.Sex LEFT OUTER JOIN DictStudyStatus ON xsStudent.StudyStatus = DictStudyStatus.Code LEFT OUTER JOIN DictResidentType ON DictResidentType.Code = xsStudent.RegisterType
where UnitiveId like '%2001______' and UnitiveId like '0101010001%' and RegionCode != 'aa' and (HomePhone != '11' or HomePhone != '22') and (StudentName!= 'cc' or StudentName!= 'dd' )
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货