Hello,
This is a very simple question and Im sorry if it has been asked before but I could not find any information on it...
What I need to do is:
I have two tables...both with exactly the same fields and all I need to do is copy all the records from one table and put them in the other one. I figured there was a merge command but when I researched this all I saw was MERGE TABLES which are far more complicated than what I am trying to accomplish.
Thanks, Kevin
What you want has nothing at all to do with merging, it is merely copying. Try something like
INSERT INTO table1 SELECT * FROM table2
Note: if both tables a different column-types or numbers, you must specify which columns to use.
