select T0.itemcode as '物料编码' ,T1.U_wlmc as '物料描述' , T1.suppcatnum as '生产厂家', sum(T0.Quantity ) as '总数量'
from inv1 T0
inner join oitm T1 on T0.itemcode=T1.itemcode group by T0.itemcode,T0.Dscription,T1.suppcatnum,T1.U_wlmc
想查在一段时间内的销售,刚加having ,但某些物料数量不能加到一起,怎么办?
from inv1 T0
inner join oitm T1 on T0.itemcode=T1.itemcode group by T0.itemcode,T0.Dscription,T1.suppcatnum,T1.U_wlmc
想查在一段时间内的销售,刚加having ,但某些物料数量不能加到一起,怎么办?
select T0.itemcode as '物料编码' ,T1.U_wlmc as '物料描述' , T1.suppcatnum as '生产厂家', sum(T0.Quantity ) as '总数量'
from inv1 T0
inner join oitm T1 on T0.itemcode=T1.itemcode and T1.date bewteen '' and ''--假设时间字段在T1中为date
group by T0.itemcode,T0.Dscription,T1.suppcatnum,T1.U_wlmc
from inv1 T0 inner join oitm T1 on T0.itemcode=T1.itemcode
where 时间 between 时间1 and 时间2
group by T0.itemcode,T0.Dscription,T1.suppcatnum,T1.U_wlmc