求一SQL查询，困扰好多天了,该如何解决

求一SQL查询，困扰好多天了
@a=sum(t1.c1)
@b=sum(CASE WHEN t2.d= 1 
THEN t2.e
ELSE t2.e/100 * @a)
t1.f=t2.f
求@a-@b的SQL，大虾帮忙啊，小弟感激不尽

[解决办法]
select @a-@b
[解决办法]
把表给出来
[解决办法]

SQL code

select    @a=sum(t1.c1),    @b=sum(CASE WHEN t2.d= 1 THEN t2.e ELSE t2.e/100 *@a end),    @a-@bfrom    t1,t2where     t1.f=t2.f
[解决办法]
SQL code
declare @a as intselect @a = sum(t1.c1) from t1declare @b as intselect @b = sum(CASE WHEN t2.d = 1 THEN t2.e ELSE t2.e/100 * @a) from t1 , t2 where t1.f=t2.f select @a - @b
[解决办法]
SQL code
declare @a decimal(10,2),@b decimal(10,2)select @a=sum(c1) from t1select @b=sum(CASE WHEN t2.d= 1 THEN t2.e ELSE t2.e/100 * @a end) from t1,t2 where t1.f=t2.fselect @a-@b
[解决办法]
我在4楼的是返回一个值.
[解决办法]
sum只返回1行阿，你没有group，返回什么列
[解决办法]
关注，学习！
[解决办法]
看不懂
[解决办法]
..
[解决办法]
..