I always get an error " virtual column must have explicit name"

I wrote a query to execute and store result in another table..I query does
sum operation on fields with related keys....

On 28 Aug 2003 04:38:57 -0700, aksivaram2k2 (AT) yahoo (DOT) com (SRam) wrote:

If you're selecting into a temp table, then any column with aan
aggregate function requires a column name . . . . e.g.

select company, count(*) comp_count
from some_table
group by 1
into temp som_temp_table


JWC

On Thu, 28 Aug 2003 07:38:57 -0400, SRam wrote:

You need to name the virtual columns created by the SUM aggregation function
using a column alias, ala:

select colone, coltwo, SUM( colthree ) AS sum_of_three
from mytable
INTO TEMP my_temp_table;

This is because the corresponding column in the temp table needs a column name.
When you select from the temp table use the alias to identify the column that
resulted from the aggregation (SUM).

Art S. Kagel