Re: Left Join Across Two Databases
| From: | Christian Reiniger | Date: | Thu, 05 Apr 2001 10:06:12 +0000 |
| Subject: | Re: Left Join Across Two Databases | ||
| References: | 1 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-47223@lists.php.net to get a copy of this message | ||
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