[Q] Sum on differents fields

I have 2 tables A and B.
For the moment I have 4 request on them :

select sum (quantite) from A ;
select sum (quantite) from A and B where A.id=B.id and B.mn='O' ;
select sum (quantite) from A and B where A.id=B.id and B.pp='O' ;
select sum (quantite) from A and B where A.id=B.id and B.mp='O' ;

Can I optimized these four requests in one ? (because each request take 30 seconds and I execute them 150 times)

Thanks a lot Received on Mon Aug 09 1999 - 02:50:22 CDT