sql query question

I've got a grouping problem.
I want to create 2 columns with the sum of field1 where the sum of the
first column is of the field1 where field2 equals value1 or value2 and
the second sum of field1 where field2 equals equals value3 or value4.
I've got a solution but the performance is so poor because it is with a
subquery:

select sum(field1)
( select sum(tmp.field2)
from table1 as tmp
where tmp.key = key
and field2 = value3
or field2 = value4
)
from table1
where field2 = value1
or field2 = value2

Has anyone a more potent solution to my problem????

You can use CASE expressions:

SELECT SUM(CASE WHEN field2 IN (value1, value2)
THEN field1
ELSE 0
END) AS sum1,
SUM(CASE WHEN field2 IN (value3, value4)
THEN field1
ELSE 0
END) AS sum2
FROM table1
WHERE field2 IN (value1, value2, value3, value4);

--
Plamen Ratchev
http://www.SQLStudio.com