SELECT A.ID As ID1,E.Name KJWL,F.ZWMC SJRGJ,B.*,C.Number,C.NAME,
(CASE WHEN B.PPCC <> 'CC' THEN
(CASE WHEN IsNull(KHYZHJE,0)<>0 THEN (IsNull(KHYZHJE,0)-IsNull(ZWLSFJE,0))/IsNull(KHYZHJE,0) ELSE 0 END)
ELSE
(CASE WHEN IsNull(ZWLSFJE,0)<>0 THEN (IsNull(ZWLSFJE,0)-IsNull(KHYZHJE,0))/IsNull(ZWLSFJE,0) ELSE 0 END)
END) AS KZMLR,
(IsNull(KHYZHJE,0)-IsNull(ZWLSFJE,0)) AS KZML,
(IsNull(KHYZHJE,0)-IsNull(WLSFJE,0)) AS KFML,
(CASE WHEN B.PPCC <> 'PP' THEN
(IsNull(WLSFJE,0)-IsNull(ZWLSFJE,0))
Else
(IsNull(ZWLSFJE,0)-IsNull(WLSFJE,0)) End) AS KJML,
(CASE WHEN B.PPCC <> 'CC' THEN
(CASE WHEN IsNull(KHYZHJE,0)<>0 THEN (IsNull(KHYZHJE,0)-IsNull(WLSFJE,0))/IsNull(KHYZHJE,0) ELSE 0 END)
ELSE
(CASE WHEN IsNull(WLSFJE,0)<>0 THEN (IsNull(WLSFJE,0)-IsNull(KHYZHJE,0))/IsNull(WLSFJE,0) ELSE 0 END)
END) AS KFMLR
FROM W_KHYD A Inner JOIN w_TJB B ON A.InnerID=B.InnerID
Left JOIN b_KHZLZB C ON A.KHBM=C.InnerID --关键是这样.如果改成Inner Join时间会超过50秒
LEFT JOIN B_KJWL E ON A.KJWL=E.InnerID
LEFT JOIN B_GJB F ON A.SJRGJ=F.InnerID
WHERE
A.YLSJ>(Case WHEN CONVERT(int,IsNull(C.JZR,'26'))>31 THEN '2011-01-31 23:59:59'
WHEN CONVERT(int,IsNull(C.JZR,'26'))<1 THEN '2011-01-26 23:59:59'
ELSE DateAdd(Day,CONVERT(int,IsNull(C.JZR,'26'))-1,'2011-01-01 23:59:59') END)
AND A.YLSJ<=(Case WHEN CONVERT(int,IsNull(C.JZR,'26'))>28 THEN '2011-02-28 23:59:59'
WHEN CONVERT(int,IsNull(C.JZR,'26'))<1 THEN '2011-02-26 23:59:59'
mark一下..不知道是什么原因.Inner join 反倒没有Left Join 快
分享到:
相关推荐
inner join、 left join 、right join、 outer join之间的区别
left join right join inner join 区别和联系
SQL中的left outer join,inner join,right outer join用法详解
SQL语句left join/right join/inner join 的用法比较 SQL语句left join/right join/inner join 的用法比较
(Left join , Right Join, Inner Join)用法详解,对Left join , Right Join, Inner Join完全掌握,由浅入深,真正领悟。
比较实用的方法,已经用到项目里,很好用的一个方法
SQL语句inner join,left join ,right join连接的不同之处, 非常实用
Mysql之innerjoin,leftjoin,rightjoin详解.pdf
Join on/inner join on/full join on/full outer join on/left join on/right join on/cross join on; 在使用jion时,on和where条件的区别;
NULL 博文链接:https://appofis.iteye.com/blog/467692
SQL 外链接操作小结 inner join left join right join
Left join , Right Join, Inner Join 的相关内容,非常实用
主要介绍了inner join 内联与left join 左联的实例代码,需要的朋友可以参考下
主要介绍了SQL之left join、right join、inner join的区别浅析,本文讲解了它们的区别并给出了实例,需要的朋友可以参考下
下面是例子分析表A记录如下: aID aNum 1 a20050111 2 a20050112 3 a20050113 4 a20050114 5 a20050115 表B记录如下: bID bName 1 2006032401 2 2006032402 3 2006032403 4 2006032404 8 2006032408 ...
通俗易懂的分析关联查询left,right,inner join
表的数据有:一、内连接-inner jion :最常见的连接查询可能是这样,查出学生的名字和成绩:[sql] view plain copy select s.
这三者的区别很多人都应该不是很清楚,包括我自己,下面我们一起来看看,如果你使用join连表,缺陷的情况下是inner join,另外,开发中使用的left join和right join属于outer join,而outer join还包括full join....