Volkan, On 4/14/05, VOLKAN ÖZÇELİK <volkan.ozcelik at gmail.com> wrote: > SELECT taktar,taktut, "sum(taktut)" as toplam FROM p_taksit > WHERE (necessary filters) > > which returns a single row.: > > Apr 14 2005 12:00 AM - 95.38 - "sum(taktut)" > > When I alter the query to: > > SELECT taktar,taktut, sum(taktut) as toplam FROM p_taksit > WHERE (necessary filters) ... > I get around 32000+ rows (the entire table), the returned > result is not filtered by (necessary filters) as well. What are you doing in "(necessary filters)"? The only thing that comes to mind is that if you are doing some kind of result limiting (like MySQL's LIMIT clause), then the database might be incorrectly using the table's stored sum in the system catelog. But, if you're offering it a date range in the WHERE clause, etc., it shouldn't be using that stored value. Still, aside from serious deviation in Sybase from SQl standard, I don't see us being able to help without seeing the WHERE clause. -- Matt Warden Miami University Oxford, OH, USA http://mattwarden.com This email proudly and graciously contributes to entropy.