title: Best way to do an Inner Join using the Zend Framework?
body: <p>It seems like there's a few different ways to join two tables using the Zend Framework, but I've never done it before so I don't know which is the best way to do it.</p>
  
  <p>This is what I'm trying to do...</p>
  
  <p>I have 3 tables in my database:</p>
  
  <pre><code>users
      ( id , name )
  groups
      ( id , name )
  group_members
      ( id , group_id , user_id )
  </code></pre>
  
  <p>I'm trying to look up the groups that a user belongs to and display that to the user. This SQL statement pretty much does the job (though there may be a better way to write it). It only returns the columns I'm concerned with which are the group's id and title.</p>
  
  <pre><code>    SELECT groups.id, groups.title
      FROM group_members
          INNER JOIN groups
          ON groups.id = group_members.group_id
      WHERE user_id = $userId
  </code></pre>
  
  <p>How can I do this with the Zend Framework?</p>