I have the following sql select statement :

SELECT  SUM(IIF(division = 'Northern',1,0)) AS NODQTY, SUM(IIF(division = 'Northern',tonnage,0)) AS NODTonnage,;
      SUM(IIF(division = 'New England',1,0)) AS NEDQTY, SUM(IIF(division = 'New England',tonnage,0)) AS NEDTonnage,;
      SUM(IIF(division = 'Mid-Atlantic',1,0)) AS MADQTY, SUM(IIF(division = 'Mid-Atlantic',tonnage,0)) AS MADTonnage,;
      SUM(IIF(division = 'Mid-South',1,0)) AS MSDQTY, SUM(IIF(division = 'Mid-South',tonnage,0)) AS MSDTonnage,;
      SUM(IIF(division = 'Southern',1,0)) AS SODQTY, SUM(IIF(division = 'Southern',tonnage,0)) AS SODTonnage,;
      SUM(IIF(division = 'Mid-West',1,0)) AS MWDQTY, SUM(IIF(division = 'Mid-West',tonnage,0)) AS MWDTonnage,;
      SUM(IIF(division = 'North West',1,0)) AS NWDQTY, SUM(IIF(division = 'North West',tonnage,0)) AS NWDTonnage ;
FROM curProjects  ;
INTO CURSOR curTemp WHERE !DELETED() GROUP BY division

This produces a cursor with something similar to the following:

Nodqty  Nodtonnage   Nedqty    Nedtonnage    Madqty   Madtonnage ...
0           0          0            0         68        25712
0           0          20           52276      0         0
143       540593       0            0          0         0

Is there a way to construct the sql select statement so that I get one line like the following:

Nodqty  Nodtonnage   Nedqty    Nedtonnage    Madqty   Madtonnage ...
143     540593         20        52276        68      25712

Thanks in advance,