 <p>You need</p> <pre><code>$select = $this-&gt;select() -&gt;from(array('mpp' =&gt; 'menu_profiles_products'), array('NAME' =&gt; 'p.name', 'PRICE' =&gt; 'p.price*mp.added_value/100')) -&gt;join(array('p' =&gt; 'products'), 'p.id = mpp.product_id') -&gt;join(array('mp' =&gt; 'menu_profiles'), 'mp.id = mpp.profile_id') -&gt;where('mpp.profile_id = ?', $profileID); $adapter = new Zend_Paginator_Adapter_DbTableSelect($select); return $adapter; </code></pre> <p>OR if you want use Zend_Db_Select</p> <pre><code>$select = $this-&gt;getDefaultAdapter()-&gt;select() -&gt;from(array('mpp' =&gt; 'menu_profiles_products'), array('NAME' =&gt; 'p.name', 'PRICE' =&gt; 'p.price*mp.added_value/100')) -&gt;join(array('p' =&gt; 'products'), 'p.id = mpp.product_id') -&gt;join(array('mp' =&gt; 'menu_profiles'), 'mp.id = mpp.profile_id') -&gt;where('mpp.profile_id = ?', $profileID); $adapter = new Zend_Paginator_Adapter_DbSelect($select); return $adapter; </code></pre>