Hello everyone

I'm using this select command:

select sum(ansdur),sum(retaildur),sum(retailcost) from myTable where .... into table mynewTable.dbf

The problem is that the field names in "mynewTable.dbf" are different from "myTable.dbf".
"myTable.ansdur" is now "mynewTable.sum_ansdur"
"myTable.retaildur" is now "mynewTable.sum_retail"
"myTable.retailcost" is now "mynewTable.sum_retai2"

Is there a way creating "mynewTable" with exact fields as "mytable" by using tha above SQL command?

Thanks