起因
DELETE XXX where not(FLDA ='校长' or FLDB='陈')
这是什么啊

开始
CREATE TABLE #TABLE
(
FLDA VARCHAR(30)
,FLDB VARCHAR(30)
)
INSERT INTO #TABLE SELECT '校长',''
INSERT INTO #TABLE SELECT '老师','陈'
INSERT INTO #TABLE SELECT '老师','lin'
INSERT INTO #TABLE SELECT '其它','吴'

--捞出全部
select * from #TABLE A

--不要捞校长
select * from #TABLE A
where not(FLDA ='校长' )

--写法1.不要捞校长 + 不要捞姓陈的.
select * from #TABLE A
where not(FLDA ='校长' or FLDB='陈')

--写法2.不要捞校长 + 不要捞姓陈的
select * from #TABLE A
where not(FLDA ='校长' ) AND NOT ( FLDB='陈')

--写法3.不要捞校长 + 不要捞姓陈的
select * from #TABLE A
where FLDA !='校长' AND FLDB!='陈'

德摩根定律

谢谢alien663邦友的回馈,原来它是个定律
select * from (select 1 x,11 y union select 2,22 union select 3,33 union select 4,44) a
where not ( x=1 or x=2 or y=33)

select * from (select 1 x,11 y union select 2,22 union select 3,33 union select 4,44) a
where x!=1 and x!=2 and y!=33