|
O.P. Easy way to copy data from one database table to another
Needing some SQL help here. I'm trying to find an easier way of creating a query that will take values from a row on one table, and insert the data onto another. Most of the field names are the same, save a few.
What I want to know, is if there's an easier way than using a SELECT on the first table, saving the data to variables/an array, and using an INSERT on the second table.
I have attached a structure dump of the tables in question
Any suggestions?
 Attachment: structure.txt (5.2 KB)
This file has been downloaded 132 time(s).
This post was edited on 01-14-2008 at 05:08 PM by MeEtc.
![[Image: signature/]](http://www.meetcweb.com/signature/) ![[Image: sharing.png]](http://www.meetcweb.com/files/sharing.png)
I cannot hear you. There is a banana in my ear. | 
/ 
![[Image: markee.png]](http://mark.kernke.org/markee.png)