Join question

Hi gang:

I'm trying to understand joins,

Here's the situation. I have two tables (user1, user2) in one database:

The common field between the two tables is "username". I want to take fields "login" and "password" from user2 and populate the same fields in user1.

Currently, the table user1 has 5303 entries, whereas user2 has 5909.

What I want at the end of this is for table user1 to have the same number of entries as table user2.

Now, how do I set up the query?

TIA for any suggestions.

Cheers,

tedd

PS: Side note -- will safe_mode ON cause problems with this?

--
-------
http://sperling.com http://ancientstones.com http://earthstones.com
.

Quantcast