求个sql语句 access

[aelfintiger]

表A(入库)
hth cdate sl
001 2016-9-1 3000
002 2016-9-1 200

表B(出库)
hth cdate sl
001 2016-9-2 1000
002 2016-9-3 20

如何得到如下库存表：
hth cdate sl
001 2016-9-1 3000
001 2016-9-2 2000
002 2016-9-1 200
002 2016-9-3 180

[Neo_whl]

--随便写了个，可以继续优化:
create table #input
(hth char(3),
 cdate datetime,  
 sl int
)

insert into #input
select '001','2016-9-1',3000 union all
select '002','2016-9-1',200

go
create table #output
(hth char(3),
 cdate datetime,  
 sl int
)
go
insert into #output
select '001','2016-9-2',1000 union all
select '002','2016-9-3',20

select i.* from #input as i join #output as o on i.hth=o.hth union all
select o.hth,o.cdate,i.sl-o.sl from #input as i join #output as o on i.hth=o.hth
order by i.hth,i.cdate

[卖水果的net]

select hth,    cdate,              sl from A
union all
select hth,    cdate,              sl from B
order by 1,2

[中国风]

用以下方法测测

SELECT hth,cdate,(SELECT SUM(sl) FROM A WHERE hth=t.hth AND cdate<=t.cdate)-(SELECT SUM(sl) FROM B WHERE hth=t.hth AND cdate<=t.cdate) sl1 FROM A AS t
UNION ALL
SELECT hth,cdate,(SELECT SUM(sl) FROM A WHERE hth=t.hth AND cdate<=t.cdate)-(SELECT SUM(sl) FROM B WHERE hth=t.hth AND cdate<=t.cdate) sl1 FROM B AS t
ORDER BY hth,cdate

[rings2000]

每天的库存，学习了ing。