title: Best approach dealing with joins in Zend Framework?
body: <p>Well it is more like a design question.
  There are two ways I know to use joins in the Zend Framework</p>
  
  <ol>
  <li>Deal with it using instance of Zend table( its Select obj)</li>
  <li>Deal with it using the instance of Zend Db (its Select obj)</li>
  </ol>
  
  <p>in the first approach it seems really strange to me - the some table have to be dealing with other tables too, which is not quite good, messy, at least when I read method name getData() - I assume that it deals with the data of its own.</p>
  
  <p>Second one it is quite better, you can have some class that acts as a service - NodeService, and it will deal with tables node and node_translation ,but it also arises question why would we need Zend Table in this case.
  I hope I could explain myself good enough
  thanks.</p>