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-9-20# ) )  and GoodsName like '%闂傚啫寮剁划锕傚箥é�?%' Order By  Preface ,ID Desc<br />Sql�������ڴ����<br />��ѯ���ݵ�ʱ���ִ����������IJ�ѯ�����Ƿ���ȷ��