title: Joining Tables With Zend Framework PHP
body: <p>I am relatively new to the Zend Framework.</p>
  
  <p>I understand the usage of Zend_Table and can obtain data using the Zend functions from the table associated with that class.</p>
  
  <p>For example I have a video table and in another table I have the association between the video and what category it is in.</p>
  
  <p>Im a little stumped how to active a select like the following within the framework:</p>
  
  <p>SELECT * FROM <code>video</code>,<code>category</code> WHERE <code>category</code>.<code>category_id</code> = 3 AND <code>video</code>.<code>id</code> = <code>category</code>.<code>video_id</code></p>
  
  <p>Any advice would be great.</p>
  
  <p>Thanks.</p>