sql不等于0的表达式?

[ningyong58]

Sql = "Select distinct abs(lineStartPoint0 - lineEndPoint0) " & _
"from [Line$] Where Layer = '粗实线' " & _
" and abs(lineStartPoint0 - lineEndPoint0) <> 0 "
程序成立
问:为什么改成下式就不成立
Sql = "Select distinct abs(lineStartPoint0 - lineEndPoint0) as m1 " & _
"from [Line$] Where Layer = '粗实线' " & _
" and m1 <> 0 "

[feiyun0112]

m1是别名，不是真正的列

*****************************************************************************
欢迎使用CSDN论坛专用阅读器 : CSDN Reader(附全部源代码)

http://feiyun0112.cnblogs.com/

[ningyong58]

只能用这各种方法
Sql = "Select distinct abs(lineStartPoint0 - lineEndPoint0) " & _
"from [Line$] Where Layer = '粗实线' " & _
" and abs(lineStartPoint0 - lineEndPoint0) <> 0 "

没有什么其它方法了吗?谢谢.

[xiaoai834407784]