title: How to return inner join query result
body: <p>I have some data from 2 databases that i want to return back to the screen
  So usually i do something like: </p>
  
  <pre><code>foreach($this-&gt;seminar-&gt;readSubscription() as $value) {
      $this-&gt;content .= '&lt;tr&gt;';
      $this-&gt;content .= '&lt;td&gt;'.$value-&gt;title.'&lt;/td&gt;';
  
      $value-&gt;title is then the title from a table.
  </code></pre>
  
  <p>But now i need 2 different id's from 2 different tables so i tried stuff like</p>
  
  <pre><code>$value-&gt;seminar-&gt;id;
  </code></pre>
  
  <p>or something like this:</p>
  
  <pre><code>$value-&gt;seminar.id;
  </code></pre>
  
  <p>But nothing seems to work any ideas?</p>
  
  <p>This is my query:</p>
  
  <pre><code>$result = $this-&gt;getDb()-&gt;query($query);
      $values = array();
      while(($row = $result-&gt;fetchObject()) !== false) {
          $values[] = $row;
      }
      return $values;
  </code></pre>