title: How to use different datasources in a Query using cakephp3?
body: <p>I'm working on a cakePHP3 project which does have 3 different datascources. I have one main model, called application, which should have two <code>hasOne()</code> associations to two models with a different datascource as Model Application. I have created the two models and pointed the two Model Tables to their datascources with <code>defaultConnectionName()</code>.</p>
  
  <p>Now I added two <code>hasOne()</code> relations to my ApplicationsTable object and recieve an sql error, when trying to <code>Applications-&gt;get()</code>. This is clear as in the SQL Statement their isn't any stating of a datasource on the FROM and JOIN part, like <code>SELECT * FROM datasource1.myTable</code></p>
  
  <p>I had a look into the cakephp framework ORM/Query class and the Query object only seems to have one datasource connection as a class attribute. </p>
  
  <p>Is there a way to use different datascources in data retrieval using cake ORM or should I just use a custom query here?</p>
  
  <p>Thanks in advance!</p>