Table employees:

 ------------------------------------
| idnumber | email | phone | address |
 ------------------------------------

Table webusers:
 -----------------------------
| idnumber | userid | website |
 -----------------------------

Table employees is completely populated. Table webusers has the idnumber and website fields completely populated. What query can I use to insert the email address from each persones record in the employees table into the userid field of their corresponding record in the webusers table?

Thanks,

Jason Joines
Open Source = Open Mind
========================


-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]



Reply via email to