Is this possible

thesandman · #1 (**permalink**) 07-08-04, 23:01

I want to join tables from 2 different databases.
I have a table in 1 db in which i want to join with in another table in abother db.

Can this be done and what is the syntax?
Thanks
Rich

jvanv8 · #2 (**permalink**) 07-09-04, 00:01

INSERT INTO `dbname1`.`table1` (row1,row2)
SELECT row1,row2 FROM `dbname2`.`table2`
WHERE row1 > 5;

would be an example.

- John

bstjean · #3 (**permalink**) 07-09-04, 12:05

Quote:

Originally Posted by thesandman

I want to join tables from 2 different databases.
I have a table in 1 db in which i want to join with in another table in abother db.

Can this be done and what is the syntax?
Thanks
Rich

You just need to prefix the tablename with the database name, for example:

select a.col1, b.col2
from database1.tablename a
inner join database2.tablename b on (a.id=b.id)
where b.col2 = 33

Internet Services

Web Development

Digital Marketing

Consumer Tech