Join question

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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

--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php


[Index of Archives]     [PHP Home]     [Apache Users]     [PHP on Windows]     [Kernel Newbies]     [PHP Install]     [PHP Classes]     [Pear]     [Postgresql]     [Postgresql PHP]     [PHP on Windows]     [PHP Database Programming]     [PHP SOAP]

  Powered by Linux