<div>
Assuming both databases are on the same machine, according to this you can: <br />
<br />
<a href="http://www.dottedidesign.com/node/14" rel="ugc">http://www.dottedidesign.com/node/14</a><br />
<br />
Basically you access the tables via database_name.table_name and the columns via database_name.table_name.c<wbr />olumn_name<wbr />. &nbsp;Then just do your usual SQL joins. &nbsp;
</div>


<div>
Both of your answers were helpful and I was able to achieve the result I needed.<br />
<br />
Thanks!
</div>


<div>
<div class="content wysiwyg-content">
Hi Experts-<br />
<br />
I am hoping someone can tell me if this is possible.<br />
<br />
I am running multiple websites for a common industry. Much of the product information is the same. I would like to have 1 database that accesses all of the product information and a separate database for each client that manages the brands they carry and the prices. Is it possible to create a single query that accesses both of these databases? The query would need to access the product information from one database and the pricing from another. I am not looking to do a union. That wouldn't work.<br />
<br />
Thanks for your help.
</div>
</div>


Hi Experts-

I am hoping someone can tell me if this is possible.

I am running multiple websites for a common industry. Much of the product information is the same. I would like to have 1 database that accesses all of the product information and a separate database for each client that manages the brands they carry and the prices. Is it possible to create a single query that accesses both of these databases? The query would need to access the product information from one database and the pricing from another. I am not looking to do a union. That wouldn't work.

Thanks for your help.

Assuming both databases are on the same machine, according to this you can: 

http://www.dottedidesign.com/node/14

Basically you access the tables via database_name.table_name and the columns via database_name.table_name.column_name.  Then just do your usual SQL joins.  

Both of your answers were helpful and I was able to achieve the result I needed.

Thanks!

Is is possible to create a single query that accesses two databases in MYSQL

Hi Experts-

I am hoping someone can tell me if this is possible.

I am running multiple websites for a common industry. Much of the product information is the same. I would like to have 1 database that accesses all of the product information and a separate database for each client that manages the brands they carry and the prices. Is it possible to create a single query that accesses both of these databases? The query would need to access the product information from one database and the pricing from another. I am not looking to do a union. That wouldn&#39;t work.

Thanks for your help.

MySQL is an open source, relational database management system that runs as a server providing multi-user access to a number of databases. Acquired by Oracle in 2009, it is frequently used in combination with PHP installations, powering most of the WordPress installations.