SQL:select id,goodsbriefintroduction,goodsgive,goodsdeduct,goodsname from [lodo_goods] where (goodslookoverauthority='all' or (goodslookoverauthority='nouser' and 0=0) or (goodslookoverauthority='alluser' and 0<>0) or ( goodslookoverauthority<>'all' and goodslookoverauthority<>'alluser' and goodslookoverauthority<>'nouser' and (not goodslookoverauthority like '%,0,%') and (0<>0))) and goodstype<>'|0|0|0|0|0|' and issueno=1 and (automaticlowershelfno=0 or ( automaticlowershelfno=1 and expirydate>=#2010-9-9# ) )  goodsbrand asc order by ,id desc<br />Sql出错：语法错误 (操作符丢失) 在查询表达式 '(goodslookoverauthority='all' or (goodslookoverauthority='nouser' and 0=0) or (goodslookoverauthority='alluser' and 0<>0) or ( goodslookoverauthority<>'all' and goodslookoverauthority<>'alluser' and goodslookoverauthority<>'nouser' and (not goodslookovera' 中。<br />查询数据的时候发现错误，请检查您的查询代码是否正确。