有表A﹐數據﹕
CName A_Nom Result1 Result2
A001 001 50 NULL
A001 002 NULL 80
A002 001 30 NULL
A002 002 NULL 40
要得到結果
CName Result1 Result2
A001 50 80
A002 30 40
必需用到where條件﹕
where A_Nom='001' or A_Nom='002'

[此贴子已经被作者于2006-9-11 11:41:35编辑过]

select CName,sum(case A_Nom when '001' then Result1
when '002' then Result1
else 0 end) as Result1,
sum(case A_Nom when '001' then Result2
when '002' then Result2 else 0 end) as Result2

select CName,sum(case A_Nom when '001' then Result1
when '002' then Result1
else 0 end) as Result1,
sum(case A_Nom when '001' then Result2
when '002' then Result2
else 0 end) as Result2 group by CName

是這樣的。。。非常感謝﹗