SQL2000查询视图的疑问
SQL2000查询视图的疑问

查询如下视图字段
SELECT viptraderid, MaterialID, LLqcqty, LLsrqty, llfcqty, lljcqty, Code
FROM dbo.vip_lljgsfczhbb

1 12 .0000000000 .0000000000 .0000000000 .0000000000 1010001                                                         
41 114 .0000000000 .0000000000 .0000000000 .0000000000 5010004                                                         
41 325 99.0000000000 .0000000000 .0000000000 99.0000000000 1060030                                                         
58 112 .0000000000 .0000000000 .0000000000 .0000000000 5010002                                                         
58 116 .0000000000 .0000000000 .0000000000 .0000000000 5010006                                                         
58 364 .0000000000 .0000000000 .0000000000 .0000000000 4010016                                                         
58 365 .0000000000 .0000000000 .0000000000 .0000000000 4010017                                                         

1/为什么如下语句查询不到内容呢?  ()
SELECT viptraderid, MaterialID, LLqcqty, LLsrqty, llfcqty, lljcqty, Code
FROM dbo.vip_lljgsfczhbb
where  LLqcqty<>0   and   LLsrqty<>0  and  llfcqty<>0  and   lljcqty<>0



2/为什么如下查询却可以正常查询到结果
SELECT viptraderid, MaterialID, LLqcqty, LLsrqty, llfcqty, lljcqty, Code
FROM dbo.vip_lljgsfczhbb
where  LLqcqty=0   and   LLsrqty=0  and  llfcqty=0  and   lljcqty=0
1 12 .0000000000 .0000000000 .0000000000 .0000000000 1010001                 &n