Using aggregrate function sum() from within Cached Query

[JigsFusion]

Hi, I have a query which returns say total 30 records. Now, form within these
30 records, I am using another Cached query which will retrive specific records
form the recordset of previous query. The code is show below :

<cfquery name ="myquery1" dbtype="QUERY">
Select sum(subtotal) from myquery
</cfquery>
subtotal field is of type varchar in the table.
myquery is the name of query which is execured before the above query. Now
when I execute query myquery1, it returns SUM function can not be used on
operand of type Varchar. But, I am able to use Max() or Min() function, still I
am unable to use SUM() function in executing cached query. It returns the
following error :

Query Of Queries syntax error.
Encountered "(" at line 2, column 27. Incorrect Select Statement, Expecting a
'FROM', but encountered '(' instead, A select statement should have a 'FROM'
construct.

Can any Please help me to sort out the problem.

[Defuse]

When you use an aggregate function in SQL, you have to set it AS something. For instance:

SELECT SUM(field) AS totalField FROM mytable

HTH