How to use multiple database adapter to query involving tables from different databases?
- by understack
I've 2 databases, which are set up as mentioned here. How can I write a SQL query which involves database_1.table_1 and database_2.table_1 ?
E.g. consider this query
$sql = "SELECT distinct database_1.users.id, database_1.users.name
FROM database_1.users, database_2.sales
WHERE database_2.sales.user_id = database_1.users.id";
How this query could be written using multiple db adapter?
Edit
I'm using 2 databases, because this way I can change actual database names in application.ini. Is there any other way I can change database names without changing sql queries?