求救？？
select a.id,a.sname,a.sstock,isnull((select sum(b.number) from m_stockcontent
as b where oddtype=1 and b.ddate>'2007-05-09' or b.ddate<'2008-05-10' and b.spid= a.id ),0) cg,
d.dname,a.spec,a.smanufa,a.stm,a.sremark from m_sp as a
join m_dw as d on d.id=a.dw join m_kc as s on s.spid =a.id
cg 这列出现的数据都是一样的？？？ 请高手指点
isnull((select sum(b.number) from m_stockcontent
as b where oddtype=1 and b.spid= a.id ),0) cg,
d.dname,a.spec,a.smanufa,a.stm,a.sremark from m_sp as a
join m_dw as d on d.id=a.dw join m_kc as s on s.spid =a.id
去掉时间就是正确的数据
为什么去掉
and b.ddate>'2007-05-09' or b.ddate<'2008-05-10'
就正确了？？？
可是我必须要知道这段时间操作的数量 ？？？？？？？？？？？？？？？？ 问题解决
select sum(number ) from m_stockcontent where spid= 1001 and oddtype=1 and ddate>'2007-05-09'
or ddate<'2008-05-10' and spid= 1001 and oddtype=1 这样做后 时间就无效了
select sum(b.number) from m_stockcontent as b
where b.spid= 1001 and oddtype=1 and b.ddate>='2010-05-10' or b.ddate<='2010-05-10' and b.spid= 1001
and b.oddtype=1
1001这行的ddate 是2008-05-09 08:38:10.377
可是以上代码照样显示数据 时间无效了 请个位看看 是什么回事
[tk05]
页:
[1]