List:General Discussion« Previous MessageNext Message »
From:Paul DuBois Date:September 11 2001 5:29pm
Subject:Re: join 2 db
View as plain text  
>Hi,
>	I'd like to retrieve data which contain in 2 db.  How could I do?
>	db1->table-in-db1->field-in-table-in-db1
>	db2->table-in-db2->field-in-table-in-db2
>	I'd not extract data to new table because I'd like to 
>retrieve data only.

Refer to the tables by qualifying them with the name of the appropriate
database, for example, as db1.table or db2.table.

This will work as long as the tables are in databases hosted by the same
server.

>
>thanks
>SF


-- 
Paul DuBois, paul@stripped
Thread
join 2 dbSommai Fongnamthip11 Sep
Re: join 2 dbPaul DuBois11 Sep