Calculo en base a datos sumarizados

Hola Victor:
Se me ocurren 3 opciones:
==-- Opcion 1: Repetir la consulta (Feo, Feo, Feo)
select tipo, numero
, sum(cantidad) as sumc
, sumd = (select sum(altura)
from base as b
where a.cod = b.cod)
, sum(cantidad)
+(select sum(altura)
from base as b
where a.cod = b.cod) as sume
from base as a
group by tipo, numero

select tipo, numero, sumc, sumd, sume
from (
select tipo, numero
, sum(cantidad) as sumc
, sumd = (select sum(altura)
from base as b
where a.cod = b.cod)
from base as a
group by tipo, numero) as A

select tipo, numero
, sum(cantidad) as sumc
, sum(altura) as sumd
, sumc+sumd as sume
from base
group by tipo, numero
== Saludos,


Javier Loria
Costa Rica
Se aprecia la inclusion de DDL (CREATE, INSERTS, etc.)
que pueda ser copiado y pegado al Query Analizer.
La version de SQL y Service Pack tambien ayuda.


"Victor" wrote in message
news:

Tengo esta sentencia

select tipo, numero, sum(cantidad) as sumc, sumd = (select sum(altura) for
base as b where a.cod = b.cod)
from base as a
group by tipo, numero

kiero un nuevo campo que me haga un calculo entre sumc y sumd... como lo
haria?