select num1+num2 as num ,a.type
 from  
(select sum(num1)as num1,type  from t2  
where t2.date >'2008-2-2'and t2.date <'2008-3-4'
group by type) as a
join
(select sum(num2)as num2,type  from t3  
where t3.date >'2008-2-2'and t3.date <'2008-3-4'
group by type )as b
on a.type=b.type

*************
num  type
65   in
88   out
*************

select num1+num2 as num ,a.type
 from  
(select sum(num1)as num1,type  from t2  
where t2.date >'2008-3-4'and t2.date <'2008-11-02'
group by type) as a
join
(select sum(num2)as num2,type  from t3  
where t3.date >'2008-3-4'and t3.date <'2008-11-02'
group by type )as b
on a.type=b.type


*************
num  type
122   in
21   out
*************

select a.*,
numin=(select sum(num1)  from table2 where sdate between  (select top 1  sdate from table1 where sdate <a.sdate order by sdate desc ) and  a.sdate  group by type having type ='in' )
+ (select sum(num2)  from table3 where sdate between   (select top 1  sdate from table1 where sdate <a.sdate order by sdate desc ) and  a.sdate   group by type having type ='in' ),
numout=(select sum(num1)  from table2 where sdate between  (select top 1  sdate from table1 where sdate <a.sdate order by sdate desc ) and  a.sdate  group by type having type ='out' )
+ (select sum(num2)  from table3 where sdate between   (select top 1  sdate from table1 where sdate <a.sdate order by sdate desc ) and  a.sdate   group by type having type ='out' )
 from Table1 a     這句搞定

這樣日期被你寫死了﹐有很多數據怎么辦

总有一天，我得把你面纱给揭了。

﹖﹖﹖﹖﹖ 說我

说妃子

西风版主来了就别跑了..你可以了上任

干嘛

那个头像的确挺漂亮的