Select Sum(..) etc

[Barney]

Sorry Ruslan,

What do you mean by 'In Standard', and a sub-query.

Something this makes me think of though is :

Regularly, it would be VERY handy if you could call a cursor... and then
call another query result from the first cursor.

Is this just out of the question or something which might be a possibility
some day ? 

Thanks

Barney




> 
>> Hi,
>> 
>> Is it not allowed to have a WHERE clause in a Select statement that includes
>> Sum(...) ?
>> 
>> This statement won't work for me ?
>> 
>> P2cur = window1.db.sqlSelect("select
>> 
>> SUM(Cost),SUM(OBV),SUM(SalePrice),Sum(DeprRec),Sum(capgain) from reportData
>> 
>> where description <> 'Sub Summary' ")
>> 
>> I am trying to get a sum of everything in the table except for the records
>> which have "Sub Summary" written into their description field.
> 
> No this not works.
> 
> In Standard this can be resolved if SubSummary is sub-query.
> 
> You can try do this now using 2 different queries,