Re: Join question

At 4:11 PM -0500 11/29/07, Robert Cummings wrote:

Grep? Loop? A single query will suffice. Also, he doesn't mention wanting to clobber the passwords in table1 when the username does already exist. Cheers, Rob.

Table1 passwords and logins are not populated. I want to take those appearing in Table2 and place them in Table1. Then, I need to take all the entries that are in Table2, but not in Table2, and add them to Table1. I think (could be wrong) it's going to be a two pass operation. First, to transfer values to records in the target table (user1) that have common username with the source table (user2); Second, to add records from the source table (user2) that don't are not found in the target table (user1). user1 Table username <-- common to both tables login <-- needs to be populated password <-- needs to be populated user2 Table username <-- common to both tables login <-- has data password <-- has data I thought that -- UPDATE user1 u1, user2 u2 SET u1.login = u2.login, u1.password = u2.password WHERE u1.username = u2.username -- would work, but it don't. Once I can transfer the known data, then I can work on increasing the number of entries that are found in user2 but are absent in user1. Still floundering. Cheers, tedd -- ------- http://sperling.com http://ancientstones.com http://earthstones.com