General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
Creating a duplicate table with SQL statement
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
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only