有一表:newofitbl,其中主键为:以下前五个字段
newofinum newoficde,newcomcde, newcde, neweda, newofisyscls
1 100022 00008 NEW00008-0000051 1 0
2 100022 00008 NEW00008-0000051 1 0
3 100022 00008 NEW00008-0000051 1 3
1 100023 00008 NEW00008-0000051 1 0现检索newofisyscls 不为3 且newoficde,newcomcde,newcde 与newofisyscls为3的那三个主键不出现
newofinum newoficde,newcomcde, newcde, neweda, newofisyscls
1 100022 00008 NEW00008-0000051 1 0
2 100022 00008 NEW00008-0000051 1 0
3 100022 00008 NEW00008-0000051 1 3
1 100023 00008 NEW00008-0000051 1 0现检索newofisyscls 不为3 且newoficde,newcomcde,newcde 与newofisyscls为3的那三个主键不出现
from newofitbl
where
newofisyscls <> 3
and
newoficde not in (select distinct newoficde from newofitbl where newofisyscls = 3)
and
newcomcde not in (select distinct newcomcde from newofitbl where newofisyscls = 3)
and
newcde not in (select distinct newcde from newofitbl where newofisyscls = 3)
我要的是select * from newofitbl where newofisyscls !=3 和 select * from newofitbl where (newcomcde,newcde,neweda) != (select newcomcde,newcde ,neweda from newofitbl where newofisyscls = 3)
这两个的结合,怎么写?
from newofitbl
where
newofisyscls <> 3
and
(newoficde || newcomcde || newcde) not in (
select distinct (newoficde || newcomcde || newcde)
from newofitbl where newofisyscls = 3)试哈,自己没有测试