>Hello everyone
>
>I'm using this select command:
>
>

select sum(ansdur) as AnsDur,sum(retaildur) as RetailDur, ;
  sum(retailcost) as 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

Yes, see changes embedded in your SQL.