Question Copy fields to another table

keb1965

Well-known member
Joined
Feb 9, 2009
Messages
103
Programming Experience
10+
I have a user database table with perhaps thousands of names. I have installed some additional software that will also use these names, however, I cannot force the new application to point to the the table and field I need it to, where all of my names are stored.

The application presumes the admin will be entering all of these names from scratch ... well, I don't want to have to do that ... it would be very time consuming to say the least.

What I would like to do is copy all of the names in my 'contacts' table (contacts.name) to the other application's table 'user_entries' ... the matching field would be 'username'. There are 2 corresponding fields I would like to copy as well ... contacts.alias -> user_entries.alias

I was advised to put together an inner join, and update but it failed with 0 records found.

Thanks
 
Nevermind ... I figured it out ....

UPDATE targettable (targetfield1, targetfield2 ....)
SELECT sourcefield1, sourcefield2 ....
FROM sourcetable
 

Latest posts

Back
Top