title: How to use Join in Zend Framework
body: <p>i am using Join query in zend..
  like</p>
  
  <pre><code>$select = $table-&gt;select()
                           -&gt;from(array('e' =&gt; 'EducationHistory'),
                                  array('status_DataDictionary_id'))
                               -&gt;join(array('r' =&gt; 'ReportOrder'),
                                      'e.id = r.EducationHistory_id',
                                      array('reportOrderStatusId' =&gt; 'r.status_DataDictionary_id'))
                          -&gt;where('r.orderBy_Organization_id = ?', 4) 
                          -&gt;where('r.orderBy_Person_id = ?', 1)            
                          -&gt;group('e.enrollno');
  </code></pre>
  
  <p>and to do that i take help from 
  <a href="http://framework.zend.com/manual/en/zend.db.select.html" rel="nofollow noreferrer">http://framework.zend.com/manual/en/zend.db.select.html</a></p>
  
  <p>but when i try to run that query an error occurs which say me that</p>
  
  <blockquote>
    <p>Select query cannot join with another</p>
  </blockquote>
  
  <p>could any one help me.?
  Thanks in advance.... :)</p>
  
  <blockquote>
    <p>table</p>
  </blockquote>