select factoryid,qualityid,customerid
from 表1 where factoryid not in (case when(qualityid='20023')
then '51001','20201'
when (qualityid='20030') then '51002','33224'
when(qualityid='10021' or qualityid='10022') then '' end)
and to_char(ndate,'yyyy-mm-dd')>='2006-08-07'
and to_char(ndate,'yyyy-mm-dd')<='2006-08-07'
问题就是这段:
factoryid not in (case when(qualityid='20023')
then '51001','20201'
when (qualityid='20030') then '51002','33224'
when(qualityid='10021' or qualityid='10022') then '' end)我要实现的是:当qualityid='20023'的时候,factoryid不能等于'510021','20201'。
当qualityid='20030'的时候,factoryid不能等于'51002','33224'。
我上面的那个语句不对,所以请教怎么写这个sql语句阿。谢谢。
from 表1 where factoryid not in (case when(qualityid='20023')
then '51001','20201'
when (qualityid='20030') then '51002','33224'
when(qualityid='10021' or qualityid='10022') then '' end)
and to_char(ndate,'yyyy-mm-dd')>='2006-08-07'
and to_char(ndate,'yyyy-mm-dd')<='2006-08-07'
问题就是这段:
factoryid not in (case when(qualityid='20023')
then '51001','20201'
when (qualityid='20030') then '51002','33224'
when(qualityid='10021' or qualityid='10022') then '' end)我要实现的是:当qualityid='20023'的时候,factoryid不能等于'510021','20201'。
当qualityid='20030'的时候,factoryid不能等于'51002','33224'。
我上面的那个语句不对,所以请教怎么写这个sql语句阿。谢谢。
解决方案 »
- 未将对象引用设置到对象的实例
- 正则表达式怎么表示一系列一位小数,用逗号分割?
- 求教.NET连接mysql的编码设置问题
- webservices作用
- C# WinForm: Cursor 如 何 使 用 嵌 入 的 彩 色 光 标
- 高手详细指点--读报软件--如何做
- md5码难道还有不同吗?
- 关于vs.net安装问题,请各位帮助
- dataset.merge()操作的相关数据集结构可不同吗?merge()是不是相当于集合的并操作呢?
- DataBinding时,怎样取得被绑定控件的值(在线等,thanks)
- 高手来答 textbox combobox如何利用AutoCompleteCustomSource绑定同一行数据的两列
- 我使用XML作web留言板,如何可以创建一个XML文件,并向其中追加留言数据?
from 表1 where factoryid not in
(select factoryid from table1 where (qualityid = '20023' and ( factoryid = '510021' or factoryid = '20201')) or
(qualityid = '20030' and ( factoryid = '51002' or factoryid = '33224')))
select factoryid,qualityid,customerid
from 表1 where to_char(ndate,'yyyy-mm-dd')>='2006-08-07'
and to_char(ndate,'yyyy-mm-dd')<='2006-08-07'
and factoryid not in
(
select case when(qualityid='20023') then '51001'
when (qualityid='20030') then '51002'
when(qualityid='10021' or qualityid='10022') then '' end
From factoryid
)
from 表1 where to_char(ndate,'yyyy-mm-dd')>='2006-08-07'
and to_char(ndate,'yyyy-mm-dd')<='2006-08-07'
and
factoryid not in
(
select case when(qualityid='20023') then (select '51001'union select '20201')
when (qualityid='20030') then (select '51002' union select '33224')
when(qualityid='10021' or qualityid='10022') then '' end
From factoryid
)
select factoryid,qualityid,customerid
from 表1 where to_char(ndate,'yyyy-mm-dd')>='2006-08-07'
and to_char(ndate,'yyyy-mm-dd')<='2006-08-07'
and
factoryid not in
(
select case when(qualityid='20023') then (select '51001'union select '20201')
when (qualityid='20030') then (select '51002' union select '33224')
when(qualityid='10021' or qualityid='10022') then '' end
From 表1
)
在看看吧,高手
from 表1 where
((qualityid='20023' and factoryid!='510021' and factoryid!='20201') or (qualityid='20030' and factoryid!='51002' and factoryid!='33224')or(qualityid!='20023' and qualityid!='20030'))and to_char(ndate,'yyyy-mm-dd')>='2006-08-07'
and to_char(ndate,'yyyy-mm-dd')<='2006-08-07'