query between 2 databases

[cathie]

hi,i would like to make a query between 2 databases

eg.

select memberID from databaseA.table1
$id=$row['memberID']
select address from databseB.table2 where memberID='".$id."' 

may i know how will the connection among these 2 databases work and how can i perform the query?

thank you!

[r937]

select two.address
  from databaseA.table1 as one
inner
  join databaseB.table2 as two
    on two.memberID = one.memberID

[cathie]

select two.address
  from databaseA.table1 as one
inner
  join databaseB.table2 as two
    on two.memberID = one.memberID

thanks you, r937!

what about the database connection?
is it just connect each database as usual?

[longneck]

you can connect to either database. it's not possible to connect to both at the same time. because you explicitly tell mysql which database to use, there is no need to specify both in the connection.

[cathie]

you can connect to either database. it's not possible to connect to both at the same time. because you explicitly tell mysql which database to use, there is no need to specify both in the connection.

oh i see...
thanks again, longneck...