join 2 db

From:	Sommai Fongnamthip	Date:	Thu, 20 Sep 2001 05:57:12 +0000
Subject:	join 2 db
Groups:	php.db
Request:	Send a blank email to php-db+get-12618@lists.php.net to get a copy of this message

Hello, I have been use PHP connect to mssql 6.5 with FreeTDS. I'd like to select data from 2 table with separate in 2 database name. How could I do this? here is some example.

       DB#1                                       DB#2
       |--> Table#1-in-DB#1                       |--> Table#1-in-DB#2
               |--field#1-in-Table#1-in-DB#1 |--field#1-in-Table#1-in-DB#2
               |--field#2-in-Table#1-in-DB#1 |--field#2-in-Table#1-in-DB#2

The result may contain data which the key of any field in Table of each DB. Thanks SF