i've two databases and want to make a join between this. But when i try to get the Data, i'll become an error:
SQLSTATE[42S02]: Base table or view not found: 1146 Table 'db1.TABLE2' doesn't exist
But TABLE2 is not in db1, it is in db2. The Models exists and the TABLE2 has in the Initialize-Function $this->setConnectionService('db2'); (db2 links on the Database in the ConnectionService)
What can i do to get Data from Tables in different Databases.