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 131 time(s).
This post was edited on 01-14-2008 at 05:08 PM by MeEtc.
I cannot hear you. There is a banana in my ear.
|