On Thursday 14 March 2002 14:39, you wrote:
> select sum(a,b) from table;
>
Asta stiu. Am dat chestia aia doar ca exemplu. Ce vreau eu sa fac e
mult mai complicat. Pe mine ma intereseaza ca serverul sa nu returneze
campurile-variabila.
Asta vreau eu sa fac:
select cont, abonat, adresa,
sum(ian+feb+mar+apr+mai+iun+iul+aug+sep+oct+nov+_dec) as alarme,
@a:=sum(if(min<21, ian*min, 0))/sum(if(min<21, ian, 0)) as ian,
@b:=sum(if(min<21, feb*min, 0))/sum(if(min<21, feb, 0)) as feb,
@c:=sum(if(min<21, mar*min, 0))/sum(if(min<21, mar, 0)) as mar,
[...]
@y:=if(a@>0, 1, 0) + if(b@>0, 1, 0) + if(c@>0, 1, 0),
@z:=(@a+@b+@c) / @y // adica media pentru campurile mai mari ca zero
// campul asta trebuie returnat
from abonati left outer join alarme on id=id_abonat
where conectat='y' and an=2002 and cont>0
group by id
order by cont;
Serghei.
---
Send e-mail to '[EMAIL PROTECTED]' with 'unsubscribe rlug' to
unsubscribe from this list.
