The following select results in one row for each subquery like this:

    Totalcost    Rejectcost
     82,9786         0,0000
    213,0541        24,2904
    315,0541        38,1831

but I would like to have the result in only one row like this:

    Totalcost    Rejectcost
    611,0868        62,4735

Anyone know how?

Select SUM(Ins_fitting.nquantity*Fittings.ncost) As totalcost, SUM(CAST(0000000.00 as Currency)) as rejectcost ;
	FROM ;
	appdata!Fittings ;
	INNER Join appdata!Ins_fitting ;
	ON  Fittings.Primary = Ins_fitting.fittingsid ;
	INNER Join appdata!Fitt_type ;
	ON  Fitt_type.Primary = Fittings.fitt_typid ;
	INNER Join appdata!Material ;
	ON  Material.Primary = Fittings.materialid ;
	INNER Join appdata!Units ;
	ON  Units.Primary = Fittings.iunitsid ;
	INNER Join appdata!mater_type ;
	ON  mater_type.Primary = Material.mat_typeid;
	WHERE  Ins_fitting.insulatorid = ( ?vp_InsulatorID );
UNION ;
Select ;
SUM(((Ins_mtrl.nquantity*ncost_unit)/((100-(Iif(Material.lreject1,Insulators.rej_perc1,000.0)+ ;
IIF(Material.lreject2,Insulators.rej_perc2,000.0)+Iif(Material.lreject3,Insulators.rej_perc3,000.0)+ ;
IIF(Material.lreject2b,Insulators.rej_perc2b,000.0)))/100))) As totalcost, ;
SUM(((Ins_mtrl.nquantity*ncost_unit)/((100-(Iif(Material.lreject1,Insulators.rej_perc1,000.0)+ ;
IIF(Material.lreject2,Insulators.rej_perc2,000.0)+Iif(Material.lreject3,Insulators.rej_perc3,000.0)+ ;
IIF(Material.lreject2b,Insulators.rej_perc2b,000.0)))/100))-Ins_mtrl.nquantity*ncost_unit) As rejectcost ;
  FROM  ;
  appdata!Mater_type ;
  INNER Join appdata!Material  ;
  On Mater_type.Primary = Material.mat_typeid ;
  INNER Join appdata!Units   ;
  On  Units.Primary = Material.iunitsid    ;
  INNER Join appdata!Ins_mtrl   ;
  On  Material.Primary = Ins_mtrl.materialid ;
  INNER Join appdata!Insulators ;
  On  Insulators.Primary = Ins_mtrl.insulatorid   ;
  WHERE  Ins_mtrl.insulatorid = ( ?vp_InsulatorID ) ;
UNION ;
SELECT ;
SUM(((Ins_operat.nquantity*(Prodgroup.nmatercost+Prodgroup.nwages+Prodgroup.nenergycost+Prodgroup.nexpenses))/;
((100-(Iif(Prodgroup.lreject1,Insulators.rej_perc1,000.0)+ IIF(Prodgroup.lreject2,Insulators.rej_perc2,000.0)+;
Iif(Prodgroup.lreject3,Insulators.rej_perc3,000.0)+ IIF(Prodgroup.lreject2b,Insulators.rej_perc2b,000.0)))/100))) As totalcost,;
SUM(((Ins_operat.nquantity*(Prodgroup.nmatercost+Prodgroup.nwages+Prodgroup.nenergycost+Prodgroup.nexpenses))/;
((100-(Iif(Prodgroup.lreject1,Insulators.rej_perc1,000.0)+ IIF(Prodgroup.lreject2,Insulators.rej_perc2,000.0)+;
Iif(Prodgroup.lreject3,Insulators.rej_perc3,000.0)+ IIF(Prodgroup.lreject2b,Insulators.rej_perc2b,000.0)))/100))-;
(Ins_operat.nquantity*(Prodgroup.nmatercost+Prodgroup.nwages+Prodgroup.nenergycost+Prodgroup.nexpenses))) As rejectcost ;
 FROM  ;
 appdata!insulators  ;
 INNER JOIN appdata!ins_operat  ;
 ON  Insulators.primary = Ins_operat.insulatorid  ;
 INNER JOIN appdata!prodgroup  ;
 ON  Prodgroup.primary = Ins_operat.prodgrpid  ;
 INNER JOIN appdata!units  ;
 ON  Prodgroup.iunitid = Units.primary  ;
 INNER JOIN appdata!prodline  ;
 ON  Prodline.primary = Prodgroup.iavsnid ;
 WHERE  Ins_operat.insulatorid = ( ?vp_InsulatorID )