Re: multiple db query
| From: | John W. Holmes | Date: | Tue, 02 Sep 2003 02:46:57 +0000 |
| Subject: | Re: multiple db query | ||
| References: | 1 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-161406@lists.php.net to get a copy of this message | ||
Aris Santillan wrote:
is it possible to query on 2 databases but with same tablename and merge its output?Probably. It depends upon your database, though. SELECT t1.column, t2.column FROM database1.table1 t1, database2.table2 t2 WHERE ... -- ---John Holmes... Amazon Wishlist: www.amazon.com/o/registry/3BEXC84AB3A5E/ php|architect: The Magazine for PHP Professionals – www.phparch.com