Posted by Jens on 10/19/05 10:19

What about a subquery ? 8Just to show you an example

Select SUM(Col1)
FROM
(
select sum(EXT_AMT) Col1 where month = "10"
) SubQuery

HTH; Jens Suessmeyer.

• Next in forum: Re: Creating Primary key with ODBC
• Prev in forum: sum of sums
• Thread view: Re: sum of sums

[Reply to this message]