SQL query

This topic is locked

SQL query	10/10/2017 4:09:59 AM
PHPRunner General questions
C chriscoogan author Hello, I have added 3 differnt database connections and wanted to join the tables together. I can join the data from the 1 of the tables from database A but not from database B. Any ideas how I can do it in PHP Runner? Thanks Chris


	Sergey Kornilov admin 10/10/2017
	Multiple connections won't help you here. Joins work on database level and not on application level. If your databases are of the same type i.e. all of them are MySQL and reside on the same database server you can simply join them specifying database name as a prefix: https://stackoverflow.com/questions/5698378/mysql-join-between-tables-in-2-different-databases