title: Symfony query with multiple databases
body: <p>This site has been great for a Symfony newbie such as myself and hopefully this will be the same experience. I have searched a lot for this question so maybe I am not using the right terminology. I have read about using services but none seem to give an example of what I need using multiple databases with different tables. So here goes, first off I am at the discretion of the current database design and I can't merge databases or recreate them, I have to use them as is. Here is the mysql query I want to use:</p>
  
  <pre><code>select name, title, rank from db1.tbl1, 
  db2.tbl1,db2.tbl2 
  where db2.tbl1.id=db2.tbl.id
  and db1.tbl1.person_id=db2.tbl2.person_id;
  </code></pre>
  
  <p>I have created connections to the db in parameters.yml and config.yml. I was thinking about creating a repository for one of the entities and then having it innerjoin the other tables from the same database but couldn't find any examples. I want to do this using best practice. I am all ears.</p>
  
  <p>I should also mention all the databases are managed by the same server.</p>