一个复杂SQL 语句问题(300)

M

mzr

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2009-09-11

• #21

如果按上述表结构和记录，把查询View_Sumwmresult和view_Wmresult改为Table表，下面这条SELECT a.DY, a.PH, a.KH, a.KX, (SELECT COUNT(b.dz) AS Zh1 FROM table2 b WHERE (a.kh = b.kh) AND (b.dz < 50) AND (b.dh <> "fk")) AS Zh1, (SELECT COUNT(b.dz) AS Zh1 FROM table2 b WHERE (a.kh = b.kh) AND (b.dz >= 50)and(b.dz<100) AND (b.dh <> "fk")) AS Zh2FROM table1 AS aWHERE (a.DY='01')ORDER BY a.DY, a.PH, a.KX, a.KH;不会报错，得到的结果也是正确。可为什么查询通不过呢

 

M

mzr

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2009-09-11

• #22

各位有没有更优化的SQL语句也可以在些贴出来[]

 

H

hctdnjy

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2009-09-11

• #23

用这个吧，也是受你的启发。可能是因为你的视图中已经用了A和B原因吧。SELECT TOP 100 PERCENT z.DY, z.PH, z.KH, z.KX, (SELECT COUNT(dz) AS Zh1 FROM View_WmResult y WHERE (z.kh = y.kh) AND (dz < 50) AND (dh <> 'fk')) AS Zh1, (SELECT COUNT(dz) AS Zh2 FROM View_WmResult y WHERE (z.kh = y.kh) AND (dz >= 50) AND (dz < 100) AND (dh <> 'fk')) AS Zh2FROM VIEW_SumWmresult AS zWHERE (z.DY='01')ORDER BY z.DY, z.PH, z.KX, z.KH

 

H

hctdnjy

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2009-09-11

• #24

还是有点麻烦的。一个人还真想不到。

 

D

de410

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2009-09-11

• #25

hctdnjy厉害啊~~

 

H

hctdnjy

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2009-09-11

• #26

谢谢。学习中

 

M

mzr

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2009-09-11

• #27

谢谢hctdnjy啊，ACCESS太弱智了，哈哈

 

M

mzr

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2009-09-11

• #28

散分了，谢谢各位的指点