Moving columns between tables

[Ishu Sharma]

Hi,

Sorry, it is a database question.

How can I move columns from one table to another with all data?

Thanks

[Mark Spritzler]

Well, I would create the table first, then write an Insert statement that would insert records into the new table from a "select" statement

like "Insert Into NEW_TABLE FIELDS(a, b, c) VALUES (Select a, b, c, FROM old_table)"

Something like that, the exact syntax for it I forgot, but easy to find with a Google Search.

Good Luck

Mark