PHP PDO LEFTJOIN on other database

Question

I have a project where I have two MySQL databases. They are completly separated. They are on two different servers. There is no way to use just one.

Is it possible to connect them both together that I could use e.g. LEFTJOIN? Or do I have to split it in two separate queries and compare them by myself?

score 3 · Answer 1 · edited Jun 13 '16 at 17:12

3

As long as a db user used to connect to first database has the access to the second, you can do cross-db joins, you just need to specify them:

SELECT db1.table.field, db2.othertable.otherfield
FROM db1.table
JOIN db2.othertable ...

edited Jun 13 '16 at 17:12

Your Common Sense

156,878
40
214
345

answered Jun 13 '16 at 17:10

Marc B

356,200
43
426
500

No they are seperate server – Mr.Tr33 Jun 13 '16 at 17:48
If they're both mysql servers, then you can use [federated](http://dev.mysql.com/doc/refman/5.7/en/federated-storage-engine.html) tables. – Marc B Jun 13 '16 at 18:26

PHP PDO LEFTJOIN on other database

1 Answers1