这样排板好难看 UNION ALL 换成 UNION 先看看
解决方案 »
- 偶尔出现"指定的网络名不再可用"的错误提示
- 关于一对多的查询,求更好的方法
- 怎样将一块SQL语句自动格式化为一个字符串当作一个字符串变量,便于在C#中作为参数,省得人工用许多加号“+”和分号“"”连接各个SQL句子。
- 请教交叉表分组的问题,并帮我看看能不能简化该语句,谢谢!~
- 技术难点,敬请zjcxc (邹建) ,txlicenhe(马可)等高手解救!!!!!!!!
- 用什么办法可以删除数据库里面所记录的所有数据?
- 同列什的文本不能合并在一起
- 介绍一本编写存储过程的好书
- 最简单的问题(为什么还问?我不会:( ...)要关联两个表,第二个怎么做啊?
- 报表服务web服务打开报错
- sql 语法问题
- 数据库如何建立能好一点呢?
(Case When Waqty>=Stqty then 1 else 0 end) as IsWarn,A=0 FROM MASTORE WHERE Isnull(StQty,0)>=isnull(Waqty,0) UNION ALL
第二個查詢
select distinct Isnull(Ma_NO,'') as Materiel,isnull(Chname,'') as Name,isnull(SMname,'') as SmName,
(Case When Waqty>=Stqty then 1 else 0 end) as IsWarn,A=1 FROM MASTORE WHERE MA_NO NOT IN
(SELECT DISTINCT MA_NO FROM IOSTORE) AND Isnull(StQty,0)<=isnull(Waqty,0) UNION ALL
第三個查詢
select distinct Isnull(Ma_NO,'') as Materiel,isnull(Chname,'') as Name,isnull(SMname,'') as SmName,
(Case When Waqty>=Stqty then 1 else 0 end) as IsWarn,A=1 FROM MASTORE WHERE
Isnull(StQty,0)<=isnull(Waqty,0) and MA_NO IN
(SELECT DISTINCT MA_NO FROM IOSTORE WHERE mA_No in
(select a.ma_No from iostore a where ((exists(select max(b.indate) from iostore b where a.ma_no=b.ma_no
group by b.ma_no having max(b.indate)<=(select filedate from setdate))) or
(exists(select max(c.outdate) from iostore c where a.ma_no=c.ma_no group by c.ma_no
having max(c.outdate)<=(select filedate from setdate))))
AND Isnull(StQty,0)<=isnull(Waqty,0)) AND Isnull(StQty,0)<=isnull(Waqty,0)) UNION All
第四個查詢
select distinct Isnull(Ma_NO,'') as Materiel,isnull(Chname,'') as Name,isnull(SMname,'') as SmName,
(Case When Waqty>=Stqty then 1 else 0 end) as IsWarn,A=2 FROM MASTORE WHERE
Isnull(StQty,0)<=isnull(Waqty,0) and MA_NO IN
(SELECT DISTINCT MA_NO FROM IOSTORE WHERE mA_No in
(select m.ma_No from iostore m where ((exists(select max(n.indate) from iostore n where m.ma_no=n.ma_no
group by n.ma_no having max(n.indate)>(select filedate from setdate))) or
(exists(select max(p.outdate) from iostore p where m.ma_no=p.ma_no group by p.ma_no
having max(p.outdate)>(select filedate from setdate))))
AND Isnull(StQty,0)<=isnull(Waqty,0)))
select distinct Isnull(Ma_NO,'') as Materiel,isnull(Chname,'') as Name,isnull(SMname,'') as SmName,
(Case When Waqty>=Stqty then 1 else 0 end) as IsWarn,A=1 FROM MASTORE WHERE
Isnull(StQty,0)<=isnull(Waqty,0) and MA_NO Not IN
(select a.ma_No from iostore a,setdate b where a.indate <b.filedate and a.outdate <b.filedate) AND Isnull(StQty,0)<=isnull(Waqty,0))
第四個sql語句
select distinct Isnull(Ma_NO,'') as Materiel,isnull(Chname,'') as Name,isnull(SMname,'') as SmName,
(Case When Waqty>=Stqty then 1 else 0 end) as IsWarn,A=2 FROM MASTORE WHERE
Isnull(StQty,0)<=isnull(Waqty,0) and MA_NO IN
(select a.ma_No from iostore a,setdate b where a.indate <b.filedate and a.outdate <b.filedate) AND Isnull(StQty,0)<=isnull(Waqty,0))而且 之間用 union 不要用union all