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
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