再请问求下面２列的和的语句怎么写？

[itmingong]

select SUM(CASE COL1 WHEN 'VAL1' THEN COL2 END) AS R1,SUM(CASE COL1 WHEN 'VAL2' THEN COL2
END) AS R2
FROM T1
上面的语句是没有问题的，求出的２个和作为２个列，我现在想把R1加R2的和列出来怎么做啊？
-- 不用子查询只能加表达式

select
SUM(CASE COL1 WHEN 'VAL1' THEN COL2 END) AS R1,
SUM(CASE COL1 WHEN 'VAL2' THEN COL2 END) AS R2,
SUM(CASE COL1 WHEN 'VAL1' THEN COL2 END) +
SUM(CASE COL1 WHEN 'VAL2' THEN COL2 END) AS R3
FROM T1
这样是可以的，但如果R1或R2里面只要有一个是NULL值的话，R3就会是NULL,怎么解决啊？

[zjcxc]

select
SUM(CASE COL1 WHEN 'VAL1' THEN COL2 END) AS R1,
SUM(CASE COL1 WHEN 'VAL2' THEN COL2 END) AS R2,
ISNULL(SUM(CASE COL1 WHEN 'VAL1' THEN COL2 END), 0) +
ISNULL(SUM(CASE COL1 WHEN 'VAL2' THEN COL2 END), 0) AS R3
FROM T1

[itmingong]

哇，老大一直都在啊，好快，呵呵，谢了！

[itmingong]

结贴！