34,590
社区成员
发帖
与我相关
我的任务
分享
declare @starttime datetime, @endtime datetime
select @starttime='2013-08-01', @endtime='2013-08-31'
select a.stockId,sum(InNumber) as InNumber,sum(OutNumber) as OutNumber,sum(TraNumber) as TraNumber
from 入库表 a
left join (select * from 出库表 where convert(varchar(10),OutTime,120) between @starttime and @endtime) b on a.stockId=b.stockId
left join (select * from 调拨表 where convert(varchar(10),TraTime,120) between @starttime and @endtime) c on a.stockId=c.stockId
where convert(varchar(10),InTime,120) between @starttime and @endtime
group by a.stockId