title: Column aggregation between multiple databases using Doctrine
body: <p>Let's say I have 2 tables in different databases that represent one model<br>
  (one-to-one column aggregation).</p>
  
  <p>schema:</p>
  
  <pre><code>Table1:
    connection: conn1
    columns:
      property1: string
  Table2:
    connection: conn2
    columns:
      table1_id: integer
      property2: string
    relations:
      Table2:
        local: table1_id
        foreign: id
        type: one
        foreignType: one
  </code></pre>
  
  <p>So I can retrieve doctrine collection from one table:</p>
  
  <pre><code>$objects = Doctrine::getTable('Table1')-&gt;findAll()
  </code></pre>
  
  <p>And then retrive properties of each object from another table:</p>
  
  <pre><code>foreach ($objects as $object) 
  {
    $object-&gt;getProperty2();
  }
  </code></pre>
  
  <p>But, this will result in too many sql requests from Table2 (one request for each object).
  What I'm trying to achieve is one sql request from each table.  </p>
  
  <p>If both tables where in one database, a simple join would do the trick. 
  Any suggestions?</p>