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