How do you copy records from one table to another?
Posted on 2005-03-07
I'd like to copy the entire contents of a table to another table, with the same schema. And I know there must be an easy one line "SELECT * FROM TABLE1" type of command.
Can anybody finish the line above to direct the results to Table2?