Re: How to Select multiples tables of different database in one query
| From: | Frédéric Hardy | Date: | Wed, 01 Sep 2004 09:47:17 +0000 |
| Subject: | Re: How to Select multiples tables of different database in one query | ||
| References: | 1 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-195377@lists.php.net to get a copy of this message | ||
Not difficult :
database db1
database db2
database db3
select db1.table3.column2, db2.table5.column1, db3.table1.column7 FROM db1.table3, db2.table5, db3.table1;
You can use alias in FROM on table like this :
select alias1.column2, alias2.column1, alias3.column7 FROM db1.table3 AS alias1, db2.table5 AS alias2, db3.table1 AS alias3;
Warning : the mysql user MUST have select (or insert, update, delete) right access on db1, db2 and db3.
Fred.
Tariq Murtaza wrote:
*Hi All,* Can someone elaborate on How to Select multiples tables of different database in one query, perticularly when using php as scripting language. Regards *TM*-- =================================================================== Frederic HARDY Email: fch@hexanet.fr HEXANET SARL URL: http://www.hexanet.fr/ ZAC Les Charmilles Tel: +33 (0)3 26 79 30 05 3, allée Thierry Sabine Direct: +33 (0)3 26 61 77 84 BP 202 - 51686 REIMS CEDEX 2 FRANCE ===================================================================