RE: MySQL Multi-DB Join

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



assuming the dtaabases are on the same server

$query = "
select db1.table1.field
from db1.table1, db2.table2
where
db1.table1.field1 = db2.table2.field2  
"

$result = mysql_query($query,$conection)

HTH

Peter


> -----Original Message-----
> From: Rod Strumbel [mailto:RStrumbel@xxxxxxxx]
> Sent: 18 March 2004 14:48
> To: 'php-db@xxxxxxxxxxxxx'
> Subject:  MySQL Multi-DB Join
> 
> 
> Is there a way through the php mysql commands
> to join tables between databases?
> 
> Is simple enough at MySQL command line, but can't for the life
> of me figure out how to do it in PHP.
> 
> Thanks all,
> 
> R
> 

-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php


[Index of Archives]     [PHP Home]     [PHP Users]     [Postgresql Discussion]     [Kernel Newbies]     [Postgresql]     [Yosemite News]

  Powered by Linux