这个储存过程如何写

这个储存过程怎么写？
我搜索从两个表里面搜索出两个值 想插入到一张零时表里面 怎么弄呢？


ALTER proc [dbo].[pro_LeaveMoney]
as

select sum(InCome) as InCome from InCome
select SUM(cost) as Cost from Spend


sum(InCome) 总收入
SUM(cost) 总花费

这两个字段

[解决办法]
create proc [dbo].[pro_LeaveMoney]
as
begin
insert into tmp(col) select sum(InCome) as InCome from InCome
insert into tmp(col) select SUM(cost) as Cost from Spend
end
go

--or
create proc [dbo].[pro_LeaveMoney]
as
begin
insert into tmp(col) 
select sum(InCome) as InCome from InCome
union all 
select SUM(cost) as Cost from Spend
end
go