SUM的问题

[zyl2001]

有两个表(入库表EnterDetail和出库表OutDetail)：
1:（表名）EnterDetail
（字段）ID , EnterDate , EnterSum
2:(表名)OutDetail
(字段) ID , OutDate ,OutSum

现在给出两个日期：beginDate,endDate

想用一条SQL语句来实现下面的功能。
查找界于beginDate---endDate时间段内 ，入库的总和（enterDetail.EnterSum）和 出库的总和(OutDetail.OutSum).

[dafu71]

select (isnull(a.entersum,0)) 入库的总和,sum(isnull(b.outsum,0)) 出库的总和
from enterdetail AA ,outdetail BB where (AA.enterdate between beginDate and
endDate) and (BB.outdate between beginDate and endDate)

[dafu71]

select (isnull(AA.entersum,0)) 入库的总和,sum(isnull(BB.outsum,0)) 出库的总和
from enterdetail AA ,outdetail BB where (AA.enterdate between beginDate and
endDate) and (BB.outdate between beginDate and endDate)

[愉快的登山者]

select (select sum(EnterSum) from EnterDetail
where EnterDate between @beginDate and @endDate) 入库的总和,
(select sum(OutSum) from OutDetail
where OutDate between @beginDate and @endDate) 出库的总和

[spurlue]

select enttotal=isnull(sum(entersum),0) ,
outtotal=(select isnull(sum(outsum),0) from outdetail
where outdate between begindate and enddate)

from enterdetail where enterdate between begindate and enddate

[pengdali]

declare @beginDate datetime,@endDate datetime
select @beginDate='1999-1-1',@endDate='2000-1-1'

select (select sum(entersum) from EnterDetail where EnterDate between @beginDate and @endDate) 入库的总和,(select sum(OutSum) from OutDetail where OutDate between @beginDate and @endDate) 出库的总和

[CrazyFor]

select isnull(a.id,b.id),sum(isnull(a.entersum,0)) 入,sum(isnull(b.outsum,0)) 出
from enterdetail a full join outdetail b on a.id=b.id
where enterdate>=... and outdate>+... and enterdate <= ... and outdate<=....
group by a.id,b.id

[zjcxc]

字段id有什么作用?

declare @dat1 datetime,@dat2 datetime
select @dat1='2003/06/01',@dat2='2003/06/30'
select a.id,a.入库,b.出库
from
(select id,sum(entersum) as 入库
from EnterDetail
where enterdate between @dat1 and @dat2
group by id) a
full join
(select sum(outsum) as 出库
from OutDetail
where OutDate between @dat1 and @dat2
group by id) b
on a.id=b.id

[wycg_cnh20]

select (select sum(entersum) from EnterDetail where EnterDate between beginDate and endDate) 入库的总和,(select sum(OutSum) from OutDetail where OutDate between beginDate and endDate) 出库的总和