Re: [Q] Sum on differents fields

Emmanuel Lecoester wrote:
>
> 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)

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

                               Maystrenko Denis (star-dragon_at_usa.net)