SQL语句难题，高手进来！！

[cbzdream]

有表Temp:

amount PayDate Bond Direction Name
100 2003-11-03 0001 1 aaa
200 2003-11-03 0001 -1 aaa
300 2003-11-04 0001 1 aaa
400 2003-11-03 0002 1 aaa
800 2003-11-03 0002 -1 aaa

要得出：
amount1 amount2 PayDate Bond Name
100 200 2003-11-03 0001 aaa
400 800 2003-11-03 0002 aaa
300 0 2003-11-04 0001 aaa

其中amount1代表Direction=1的amount的值，
amount2代表Direction=2的amount的值
在相同的PayDate下，如果Direction=1的amount的值不存在，则amount1=0，
如果Direction=-1的amount的值不存在，则amount2=0，
结果按Bond分组
请问SQL怎么写？？？谢谢！！！

[pengdali]

select
sum(case when Direction=1 then amount else 0 end) amount1,
sum(case when Direction=-1 then amount else 0 end) amount2
,Bond,PayDate,name from temp group by Bond,PayDate,name

[zjcxc]

select
amount1=sum(case when Direction=1 then amount else 0 end),
amount2=sum(case when Direction=-1 then amount else 0 end)
,Bond,PayDate,name
from temp group by Bond,PayDate,name

[银狐被占用]

select (case when Direction=1 then amount else 0 end) as amount1,
(case when Direction=-1 then amount else 0 end) as amount2,
PayDate,Bond,Name
from Temp
group by PayDate,Bond,Name