- For those who want to view such frequent look at how | Programing Reference For .Net,Java,C

For those who want to view such frequent look at how

As do a module, used previously colleagues would like to write a code with the view, but after that I have to find that the so -

Create view zc_ypz as
Select zcgs, dwdm, zysx, hj, 1 as kpml, sum (yzje) as aa, 0 as bb, 0 as cc, 0 as dd from zc_skpk
Where zcgs = 1 and zysx 10 and zysx <> <> 7 and (mlbh like'100 percent 'or mlbh like'110 percent') and mlbh not like'120 percent 'group by dwdm, zysx, hj, zcgs
Union
Select zcgs, dwdm, zysx, hj, 2 as kpml, sum (yzje) as aa, 0 as bb, 0 as cc, 0 as dd from zc_skpk
Where zcgs = 1 and zysx 10 and zysx <> <> 7 and (mlbh like'010 percent 'or mlbh like'030 percent') and mlbh not like'120 percent 'group by dwdm, zysx, hj, zcgs
Union
Select zcgs, dwdm, zysx, hj, 3 as kpml, sum (yzje) as aa, 0 as bb, 0 as cc, 0 as dd from zc_skpk
Where zcgs = 1 and zysx 10 and zysx <> <> 7 and mlbh like'040 percent 'and mlbh not like'120 percent' group by dwdm, zysx, hj, zcgs
Union
Select zcgs, dwdm, zysx, hj, 4 as kpml, sum (yzje) as aa, 0 as bb, 0 as cc, 0 as dd from zc_skpk
Where zcgs = 1 and zysx 10 and zysx <> <> 7% and mlbh like'05001 'and mlbh not like'120 percent' group by dwdm, zysx, hj, zcgs
Union
Select zcgs, dwdm, zysx, hj, as kpml 5, sum (yzje) as aa, 0 as bb, 0 as cc, 0 as dd from zc_skpk
Where zcgs = 1 and zysx 10 and zysx <> <> 7 and (mlbh not like'100 percent 'and mlbh not like'110 percent' and mlbh
Not like'010 percent 'and mlbh not like'030 percent' and mlbh not like'040 percent 'and mlbh not like'05001%') and
Mlbh not like'120 percent 'group by dwdm, zysx, hj, zcgs
Union
Select zcgs, dwdm, zysx, hj, as kpml 1, and 0 as aa, sum (yzje) as bb, 0 as cc, 0 as dd from zc_skpk
Where zcgs = 2 and zysx 10 and zysx <> <> 7 and (mlbh like'100 percent 'or mlbh like'110 percent') and mlbh not like'120 percent 'group by dwdm, zysx, hj, zcgs
Union
Select zcgs, dwdm, zysx, hj, 2 as kpml, 0 as aa, sum (yzje) as bb, 0 as cc, 0 as dd from zc_skpk
Where zcgs = 2 and zysx 10 and zysx <> <> 7 and (mlbh like'010 percent 'or mlbh like'030 percent') and mlbh not like'120 percent 'group by dwdm, zysx, hj, zcgs
Union
Select zcgs, dwdm, zysx, hj, 3 as kpml, 0 as aa, sum (yzje) as bb, 0 as cc, 0 as dd from zc_skpk
Where zcgs = 2 and zysx 10 and zysx <> <> 7 and mlbh like'040 percent 'and mlbh not like'120 percent' group by dwdm, zysx, hj, zcgs
Union
Select zcgs, dwdm, zysx, hj, 4 as kpml, 0 as aa, sum (yzje) as bb, 0 as cc, 0 as dd from zc_skpk
Where zcgs = 2 and zysx 10 and zysx <> <> 7% and mlbh like'05001 'and mlbh not like'120 percent' group by dwdm, zysx, hj, zcgs
Union
Select zcgs, dwdm, zysx, hj, as kpml 5, 0 as aa, sum (yzje) as bb, 0 as cc, 0 as dd from zc_skpk
Where zcgs = 2 and zysx 10 and zysx <> <> 7 and (mlbh not like'100 percent 'and mlbh not like'110 percent' and mlbh
Not like'010 percent 'and mlbh not like'030 percent' and mlbh not like'040 percent 'and mlbh not like'05001%') and mlbh not like'120 percent 'group by dwdm, zysx, hj, zcgs
Union
Select zcgs, dwdm, zysx, hj, as kpml 1, as aa 0, 0 as bb, sum (yzje) as cc, 0 as dd from zc_skpk
Where zcgs = 3 and zysx 10 and zysx <> <> 7 and (mlbh like'100 percent 'or mlbh like'110 percent') and mlbh not like'120 percent 'group by dwdm, zysx, hj, zcgs
Union
Select zcgs, dwdm, zysx, hj, as kpml 2, as aa 0, 0 as bb, sum (yzje) as cc, 0 as dd from zc_skpk
Where zcgs = 3 and zysx 10 and zysx <> <> 7 and (mlbh like'010 percent 'or mlbh like'030 percent') and mlbh not like'120 percent 'group by dwdm, zysx, hj, zcgs
Union
Select zcgs, dwdm, zysx, hj, 3 as kpml, as aa 0, 0 as bb, sum (yzje) as cc, 0 as dd from zc_skpk
Where zcgs = 3 and zysx 10 and zysx <> <> 7 and mlbh like'040 percent 'and mlbh not like'120 percent' group by dwdm, zysx, hj, zcgs
Union
Select zcgs, dwdm, zysx, hj, 4 as kpml, as aa 0, 0 as bb, sum (yzje) as cc, 0 as dd from zc_skpk
Where zcgs = 3 and zysx 10 and zysx <> <> 7% and mlbh like'05001 'and mlbh not like'120 percent' group by dwdm, zysx, hj, zcgs
Union
Select zcgs, dwdm, zysx, hj, 5 as kpml, as aa 0, 0 as bb, sum (yzje) as cc, 0 as dd from zc_skpk
Where zcgs = 3 and zysx 10 and zysx <> <> 7 and (mlbh not like'100 percent 'and mlbh not like'110 percent' and mlbh
Not like'010 percent 'and mlbh not like'030 percent' and mlbh not like'040 percent 'and mlbh not like'05001%') and mlbh not like'120 percent 'group by dwdm, zysx, hj, zcgs
Union
Select zcgs, dwdm, zysx, hj, as kpml 1, as aa 0, 0 as bb, 0 as cc, sum (yzje) as dd from zc_skpk
Where zcgs = 4 and zysx 10 and zysx <> <> 7 and (mlbh like'100 percent 'or mlbh like'110 percent') and mlbh not like'120 percent 'group by dwdm, zysx, hj, zcgs
Union
Select zcgs, dwdm, zysx, hj, as kpml 2, as aa 0, 0 as bb, 0 as cc, sum (yzje) as dd from zc_skpk
Where zcgs = 4 and zysx 10 and zysx <> <> 7 and (mlbh like'010 percent 'or mlbh like'030 percent') and mlbh not like'120 percent 'group by dwdm, zysx, hj, zcgs
Union
Select zcgs, dwdm, zysx, hj, 3 as kpml, as aa 0, 0 as bb, 0 as cc, sum (yzje) as dd from zc_skpk
Where zcgs = 4 and zysx 10 and zysx <> <> 7 and mlbh like'040 percent 'and mlbh not like'120 percent' group by dwdm, zysx, hj, zcgs
Union
Select zcgs, dwdm, zysx, hj, 4 as kpml, as aa 0, 0 as bb, 0 as cc, sum (yzje) as dd from zc_skpk
Where zcgs = 4 and zysx 10 and zysx <> <> 7% and mlbh like'05001 'and mlbh not like'120 percent' group by dwdm, zysx, hj, zcgs
Union
Select zcgs, dwdm, zysx, hj, 5 as kpml, as aa 0, 0 as bb, 0 as cc, sum (yzje) as dd from zc_skpk
Where zcgs = 4 and zysx 10 and zysx <> <> 7 and (mlbh not like'100 percent 'and mlbh not like'110 percent' and mlbh
Not like'010 percent 'and mlbh not like'030 percent' and mlbh not like'040 percent 'and mlbh not like'05001%') and mlbh not like'120 percent 'group by dwdm, zysx, hj, zcgs
Union
Select zcgs, dwdm, zysx, hj, 0 as kpml, sum (yzje) as aa, 0 as bb, 0 as cc, 0 as dd from zc_skpk where
Zcgs = 10 = 1 and zysx group by dwdm, zysx, hj, zcgs
Union
Select zcgs, dwdm, zysx, hj, as kpml 0, 0 as aa, sum (yzje) as bb, 0 as cc, 0 as dd from zc_skpk where
Zcgs = 2 and zysx = 10 group by dwdm, zysx, hj, zcgs
Union
Select zcgs, dwdm, zysx, hj, 0 as kpml, as aa 0, 0 as bb, sum (yzje) as cc, 0 as dd from zc_skpk where
Zcgs = 3 = 10 and zysx group by dwdm, zysx, hj, zcgs
Union
Select zcgs, dwdm, zysx, hj, 0 as kpml, as aa 0, 0 as bb, 0 as cc, sum (yzje) as dd from zc_skpk where
Zcgs = 10 = 4 and zysx group by dwdm, zysx, hj, zcgs
Union
Select b.zcgs, b.dwdm, a.zylxbh as zysx, b.hj, 1 as kpml, sum (a.ZYLX_JE) as aa, 0 as bb, 0 as
Cc, 0 as dd from zc_kpzylx a, zc_skpk b where a.kpbh b.kpbh and a.dwbh = = = 7 b.dwdm and b.zysx and
B.zcgs = 1 and a.zylxbh 10 and <> (b.mlbh like'100 percent 'or b.mlbh like'110 percent') and mlbh not like'120 percent 'group by b.dwdm, a.zylxbh, b.hj, b.zcgs
Union
Select b.zcgs, b.dwdm, a.zylxbh as zysx, b.hj, 2 as kpml, sum (a.ZYLX_JE) as aa, 0 as bb, 0 as
Cc, 0 as dd from zc_kpzylx a, zc_skpk b where a.kpbh b.kpbh and a.dwbh = = = 7 b.dwdm and b.zysx and
B.zcgs = 1 and a.zylxbh 10 and <> (b.mlbh like'010 percent 'or b.mlbh like'030 percent') and mlbh not like'120 percent 'group by b.dwdm, a.zylxbh, b.hj, b.zcgs
Union
Select b.zcgs, b.dwdm, a.zylxbh as zysx, b.hj, 3 as kpml, sum (a.ZYLX_JE) as aa, 0 as bb, 0 as
Cc, 0 as dd from zc_kpzylx a, zc_skpk b where a.kpbh b.kpbh and a.dwbh = = = 7 b.dwdm and b.zysx and
B.zcgs = 1 and a.zylxbh <> 10% and b.mlbh like'040 'and mlbh not like'120 percent' group by b.dwdm, a.zylxbh, b.hj, b.zcgs
Union
Select b.zcgs, b.dwdm, a.zylxbh as zysx, b.hj, 4 as kpml, sum (a.ZYLX_JE) as aa, 0 as bb, 0 as
Cc, 0 as dd from zc_kpzylx a, zc_skpk b where a.kpbh b.kpbh and a.dwbh = = = 7 b.dwdm and b.zysx and
B.zcgs = 1 and a.zylxbh <> 10% and b.mlbh like'05001 'and mlbh not like'120 percent' group by b.dwdm, a.zylxbh, b.hj, b.zcgs
Union
Select b.zcgs, b.dwdm, a.zylxbh as zysx, b.hj, as kpml 5, sum (a.ZYLX_JE) as aa, 0 as bb, 0 as
Cc, 0 as dd from zc_kpzylx a, zc_skpk b where a.kpbh b.kpbh and a.dwbh = = = 7 b.dwdm and b.zysx and
B.zcgs = 1 and a.zylxbh 10 and <> (b.mlbh not like'100 percent 'and b.mlbh not like'110 percent' and b.mlbh not
Like'010 percent 'and b.mlbh not like'030 percent' and b.mlbh not like'040 percent 'and b.mlbh not like'05001%')
And mlbh not like'120 percent 'group by b.dwdm, a.zylxbh, b.hj, b.zcgs
Union
Select b.zcgs, b.dwdm, a.zylxbh as zysx, b.hj, as kpml 1, and 0 as aa, sum (a.ZYLX_JE) as bb, 0 as
Cc, 0 as dd from zc_kpzylx a, zc_skpk b where a.kpbh b.kpbh and a.dwbh = = = 7 b.dwdm and b.zysx and
B.zcgs = 2 and a.zylxbh 10 and <> (b.mlbh like'100 percent 'or b.mlbh like'110 percent') and mlbh not like'120 percent 'group by b.dwdm, a.zylxbh, b.hj, b.zcgs
Union
Select b.zcgs, b.dwdm, a.zylxbh as zysx, b.hj, 2 as kpml, 0 as aa, sum (a.ZYLX_JE) as bb, 0 as
Cc, 0 as dd from zc_kpzylx a, zc_skpk b where a.kpbh b.kpbh and a.dwbh = = = 7 b.dwdm and b.zysx and
B.zcgs = 2 and a.zylxbh 10 and <> (b.mlbh like'010 percent 'or b.mlbh like'030 percent') and mlbh not like'120 percent 'group by b.dwdm, a.zylxbh, b.hj, b.zcgs
Union
Select b.zcgs, b.dwdm, a.zylxbh as zysx, b.hj, 3 as kpml, 0 as aa, sum (a.ZYLX_JE) as bb, 0 as
Cc, 0 as dd from zc_kpzylx a, zc_skpk b where a.kpbh b.kpbh and a.dwbh = = = 7 b.dwdm and b.zysx and
B.zcgs = 2 and a.zylxbh <> 10% and b.mlbh like'040 'and mlbh not like'120 percent' group by b.dwdm, a.zylxbh, b.hj, b.zcgs
Union
Select b.zcgs, b.dwdm, a.zylxbh as zysx, b.hj, 4 as kpml, 0 as aa, sum (a.ZYLX_JE) as bb, 0 as
Cc, 0 as dd from zc_kpzylx a, zc_skpk b where a.kpbh b.kpbh and a.dwbh = = = 7 b.dwdm and b.zysx and
B.zcgs = 2 and a.zylxbh <> 10% and b.mlbh like'05001 'and mlbh not like'120 percent' group by b.dwdm, a.zylxbh, b.hj, b.zcgs
Union
Select b.zcgs, b.dwdm, a.zylxbh as zysx, b.hj, as kpml 5, 0 as aa, sum (a.ZYLX_JE) as bb, 0 as
Cc, 0 as dd from zc_kpzylx a, zc_skpk b where a.kpbh b.kpbh and a.dwbh = = = 7 b.dwdm and b.zysx and
B.zcgs = 2 and a.zylxbh 10 and <> (b.mlbh not like'100 percent 'and b.mlbh not like'110 percent' and b.mlbh not
Like'010 percent 'and b.mlbh not like'030 percent' and b.mlbh not like'040 percent 'and b.mlbh not like'05001%')
And mlbh not like'120 percent 'group by b.dwdm, a.zylxbh, b.hj, b.zcgs
Union
Select b.zcgs, b.dwdm, a.zylxbh as zysx, b.hj, as kpml 1, as aa 0, 0 as bb, sum (a.ZYLX_JE) as
Cc, 0 as dd from zc_kpzylx a, zc_skpk b where a.kpbh b.kpbh and a.dwbh = = = 7 b.dwdm and b.zysx and
B.zcgs = 3 and a.zylxbh 10 and <> (b.mlbh like'100 percent 'or b.mlbh like'110 percent') and mlbh not like'120 percent 'group by b.dwdm, a.zylxbh, b.hj, b.zcgs
Union
Select b.zcgs, b.dwdm, a.zylxbh as zysx, b.hj, as kpml 2, as aa 0, 0 as bb, sum (a.ZYLX_JE) as
Cc, 0 as dd from zc_kpzylx a, zc_skpk b where a.kpbh b.kpbh and a.dwbh = = = 7 b.dwdm and b.zysx and
B.zcgs = 3 and a.zylxbh 10 and <> (b.mlbh like'010 percent 'or b.mlbh like'030 percent') and mlbh not like'120 percent 'group by b.dwdm, a.zylxbh, b.hj, b.zcgs
Union
Select b.zcgs, b.dwdm, a.zylxbh as zysx, b.hj, 3 as kpml, as aa 0, 0 as bb, sum (a.ZYLX_JE) as
Cc, 0 as dd from zc_kpzylx a, zc_skpk b where a.kpbh b.kpbh and a.dwbh = = = 7 b.dwdm and b.zysx and
B.zcgs = 3 and a.zylxbh <> 10% and b.mlbh like'040 'and mlbh not like'120 percent' group by b.dwdm, a.zylxbh, b.hj, b.zcgs
Union
Select b.zcgs, b.dwdm, a.zylxbh as zysx, b.hj, 4 as kpml, as aa 0, 0 as bb, sum (a.ZYLX_JE) as
Cc, 0 as dd from zc_kpzylx a, zc_skpk b where a.kpbh b.kpbh and a.dwbh = = = 7 b.dwdm and b.zysx and
B.zcgs = 3 and a.zylxbh <> 10% and b.mlbh like'05001 'and mlbh not like'120 percent' group by b.dwdm, a.zylxbh, b.hj, b.zcgs
Union
Select b.zcgs, b.dwdm, a.zylxbh as zysx, b.hj, 5 as kpml, as aa 0, 0 as bb, sum (a.ZYLX_JE) as
Cc, 0 as dd from zc_kpzylx a, zc_skpk b where a.kpbh b.kpbh and a.dwbh = = = 7 b.dwdm and b.zysx and
B.zcgs = 3 and a.zylxbh 10 and <> (b.mlbh not like'100 percent 'and b.mlbh not like'110 percent' and b.mlbh not
Like'010 percent 'and b.mlbh not like'030 percent' and b.mlbh not like'040 percent 'and b.mlbh not like'05001%')
And mlbh not like'120 percent 'group by b.dwdm, a.zylxbh, b.hj, b.zcgs
Union
Select b.zcgs, b.dwdm, a.zylxbh as zysx, b.hj, as kpml 1, as aa 0,
0 as bb, 0 as cc, sum (a.ZYLX_JE) as dd from zc_kpzylx a, zc_skpk b where a.kpbh = b.kpbh and
B.dwdm and b.zysx a.dwbh = = = 7 and b.zcgs and a.zylxbh 4 and 10 <> (b.mlbh like'100 percent 'or b.mlbh like
'110% ') And mlbh not like'120 percent' group by b.dwdm, a.zylxbh, b.hj, b.zcgs
Union
Select b.zcgs, b.dwdm, a.zylxbh as zysx, b.hj, as kpml 2, as aa 0, 0 as bb, 0 as cc, the sum
(A.ZYLX_JE) as dd from zc_kpzylx a, zc_skpk b where a.kpbh b.kpbh and a.dwbh = = = 7 b.dwdm and b.zysx
And b.zcgs = 4 and a.zylxbh 10 and <> (b.mlbh like'010 percent 'or b.mlbh like'030 percent') and mlbh not like'120 percent 'group by b.dwdm, a.zylxbh , b.hj, b.zcgs
Union
Select b.zcgs, b.dwdm, a.zylxbh as zysx, b.hj, 3 as kpml, as aa 0, 0 as bb, 0 as cc, the sum
(A.ZYLX_JE) as dd from zc_kpzylx a, zc_skpk b where a.kpbh b.kpbh and a.dwbh = = = 7 b.dwdm and b.zysx
And b.zcgs = 4 and a.zylxbh <> 10% and b.mlbh like'040 'and mlbh not like'120 percent' group by b.dwdm, a.zylxbh, b.hj, b.zcgs
Union
Select b.zcgs, b.dwdm, a.zylxbh as zysx, b.hj, 4 as kpml, as aa 0, 0 as bb, 0 as cc, the sum
(A.ZYLX_JE) as dd from zc_kpzylx a, zc_skpk b where a.kpbh b.kpbh and a.dwbh = = = 7 b.dwdm and b.zysx
And b.zcgs = 4 and a.zylxbh <> 10% and b.mlbh like'05001 'and mlbh not like'120 percent' group by b.dwdm, a.zylxbh, b.hj, b.zcgs
Union
Select b.zcgs, b.dwdm, a.zylxbh as zysx, b.hj, 5 as kpml, as aa 0, 0 as bb, 0 as cc, the sum
(A.ZYLX_JE) as dd from zc_kpzylx a, zc_skpk b where a.kpbh b.kpbh and a.dwbh = = = 7 b.dwdm and b.zysx
And b.zcgs = 4 and a.zylxbh 10 and <> (b.mlbh not like'100 percent 'and b.mlbh not like'110 percent' and b.mlbh not like'010 percent 'and b.mlbh not like '030% 'and b.mlbh not like'040 percent' and b.mlbh not like'05001% ') and mlbh not like'120 percent' group by b.dwdm, a.zylxbh, b.hj, b.zcgs
Union
Select b.zcgs, b.dwdm, a.zylxbh as zysx, b.hj, 0 as kpml, sum (a.ZYLX_JE) as aa, 0 as bb, 0 as cc, as dd 0
From zc_kpzylx a, zc_skpk b where a.kpbh b.kpbh and a.dwbh = = = 7 b.dwdm and b.zysx and b.zcgs = 1 and
A.zylxbh = 10 group by b.dwdm, a.zylxbh, b.hj, b.zcgs
Union
Select b.zcgs, b.dwdm, a.zylxbh as zysx, b.hj, as kpml 0, 0 as aa, sum (a.ZYLX_JE) as bb, 0 as cc, as dd 0
From zc_kpzylx a, zc_skpk b where a.kpbh b.kpbh and a.dwbh = = = 7 b.dwdm and b.zysx and b.zcgs = 2 and
A.zylxbh = 10 group by b.dwdm, a.zylxbh, b.hj, b.zcgs
Union
Select b.zcgs, b.dwdm, a.zylxbh as zysx, b.hj, 0 as kpml, as aa 0, 0 as bb, sum (a.ZYLX_JE) as cc, as dd 0
From zc_kpzylx a, zc_skpk b where a.kpbh b.kpbh and a.dwbh = = = 7 b.dwdm and b.zysx and b.zcgs = 3 and
A.zylxbh = 10 group by b.dwdm, a.zylxbh, b.hj, b.zcgs
Union
Select b.zcgs, b.dwdm, a.zylxbh as zysx, b.hj, 0 as kpml, as aa 0, 0 as bb, 0 as cc, sum (a.ZYLX_JE) as dd
From zc_kpzylx a, zc_skpk b where a.kpbh b.kpbh and a.dwbh = = = 7 b.dwdm and b.zysx and b.zcgs = 4 and
A.zylxbh = 10 group by b.dwdm, a.zylxbh, b.hj, b.zcgs;