If this is your first visit, be sure to
check out the FAQ by clicking the
link above. You may have to register
before you can post: click the register link above to proceed. To start viewing messages,
select the forum that you want to visit from the selection below.

Unanswered: Optimize my SQL statement

The following SQL statement works fine, it involves a single table. The aim of the 8 subqueries is to determine subtotals at various levels.
Just wondering if this statement can be streamlined/optimized to run better/faster or should I leave it as is.

SELECT Groupnbr AS Groupnbr, Subgrp AS Subgrp, SECTION AS Section,
(SELECT Sum(Sales-Exp) from BlueTable where subgrp IN ('A','B')) as SubTot1,
(SELECT Sum(Sales-Exp) from BlueTable where subgrp IN ('C','D')) as SubTot2,
(SELECT Sum(Sales-Exp) from BlueTable where subgrp IN ('C','D','E')) as SubTot3,
(SELECT Sum(Sales-Exp) from BlueTable where subgrp IN ('F','G')) as SubTot4,
(SELECT Sum(Sales-Exp) from BlueTable where subgrp IN ('F','G','H')) as SubTot5,
(SELECT Sum(Sales-Exp) from BlueTable where subgrp IN ('K','L')) as SubTot6,
(SELECT Sum(Sales-Exp) from BlueTable where subgrp IN ('M','P')) as SubTot7,
(SELECT Sum(Sales-Exp) from BlueTable where subgrp IN ('M','P','Q')) as SubTot8
from BlueTable

I have no performance problem at the moment (the DB has barely 200 records, just started being used). Being a newbie I am not sure if this is the best or good way to go about it, but how about when it reaches a few hundred thousand records? I read somewhere that it's better to use Joins than subquerries (?), but have no clue how to replace each one of these subqueries with a Join. If my subquerries might pose a performance problem in the future and there is a better approach, please suggest. Thanks