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,
Warning 2 : it is a mysql example. Whith other DBM, i don't know how to
do that, but i think that its exactly the same thing.
PHP version : mysql_query($query).
Fred.
Tariq Murtaza wrote:
*Hi All,*
Can someone elaborate on How to Select multiples tables of different
database in one query,