Re: [SQL] sum of two queries

Kyle Bateman wrote:

>>
>
> I explained my problem badly.
>
> Here's the full thing.  I'm doing this, which works:
>
> select -sum(tquant) from mtr_reg where
>     status = 'clsd' and
>     fr_proj = 20 and
>     pnum = '1122'
> union
> select sum(tquant) from mtr_reg where
>     status = 'clsd' and
>     to_proj = 20 and
>     pnum = '1122'
> ;

I think this will work (it seems to work when I tried it with my
database):

select sum(a.tquant - b.tquant) from mtr_reg as a, mtr_reg as b where
a.status = 'clsd' and
b.status = 'clsd' and a.pnum = '1122' and b.pnum = '1122' and a.fr_proj
= 20 and b.to_proj = 20;


-Tony