select a.Djbh as
客户进货单号,d.Dwmch
供应商,a.Rq
购入日期, c.Spbh
产品编号,c.Spmch
产品名称,c.Shpgg
规格,c.Shpchd
生产企业,b.Pihao
批次, ''
效期, ''
批准文号,c.Dw
计量单位名称,b.Shl
数量,b.Hshj
单价,b.Hsje
金额 from Cwk a,ywmxk b,Spkfk c,Mchk d
where a.Djbh=b.Djbh and b.Spid=c.Spid and a.Dwbh=d.Dwbh and a.Rq
between @SDate and @EDate and c.Shpchd like ''
JHA 采购入库单 JHC 采购退货单 XSA 销售出库单 XSC 销售退货单
------解决方案--------------------
这是什么sql？