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>=#2024-11-28# ) ) GoodsBrand DESC Order By ,ID Desc
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' 中。
查询数据的时候发现错误,请检查您的查询代码是否正确。