"Jonathan Chum" <[EMAIL PROTECTED]> wrote:
> I have one table on one database and another table on another
> database. I want to perform a left join these two tables in MySQL. I
> don't think it's possible, but cuious if there is a "method" that can
> be coded in PHP to do this?
Just prepend the DB name to the table selecting from:
SELECT table_1_from_db_connected_to, other_db_name.table_2 ...
And make sure that the user for the first DB has permissions for the second
DB.
--
Steve Werby
President, Befriend Internet Services LLC
http://www.befriend.com/
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]
