select * from h_v_Sc_MouldProdInHouseBillList where 库存组织='蓝海实业集团' and CONVERT(varchar(100),日期, 23) >= '2022-02-23' and CONVERT(varchar(100),日期, 23) <= '2022-03-25' and 库存组织 like '%1%' and CONVERT(varchar(100),日期, 23) >= '2022-02-23' and CONVERT(varchar(100),日期, 23) <= '2022-03-25'order by hmainid desc
|