On Thursday 05 April 2001 07:23, you 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?
>
> If you think there's is a problem with my schema, well the boss wants
> to have the user data on another database totally seperated from
> features of the portal. So I have a big problem on my hands.
>
> Any help would be much grateful!
SELECT * FROM database1.table1A, database2.table2 B where (A.id = B.id);
should work fine
--
Christian Reiniger
LGDC Webmaster (http://sunsite.dk/lgdc/)
Error 032: Recursion error - see error 032
--
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]
