title: Zend DB select only 1 table with multiple joins
body: <p>I'm using Zend DB to generate a query using the following code:</p>
  
  <pre><code>$table-&gt;select()
          -&gt;setIntegrityCheck(false) //required for multi-table join
          -&gt;from('modules')
          -&gt;joinInner(
              'basket_modules',
              'modules.id = basket_modules.id')
          -&gt;joinInner(
              'baskets',
              'baskets.id = basket_modules.basket_id')
          -&gt;where('baskets.id = ?', $this-&gt;id);
  </code></pre>
  
  <p>This generates the SQL:</p>
  
  <pre><code>SELECT modules.*, basket_modules.*, baskets.*
  FROM modules
  INNER JOIN basket_modules ON modules.id = basket_modules.id
  INNER JOIN baskets ON baskets.id = basket_modules.basket_id
  WHERE (baskets.id = '3')
  </code></pre>
  
  <p>My problem here is with the SELECT part, it's selecting all 3 tables instead of just modules, which is the one I want. So the query I would want to generate is:</p>
  
  <pre><code>SELECT `modules`.*
  FROM `modules`
  #etc...
  </code></pre>
  
  <p>How can I do this? If I edit the query manually and run it, it returns what I want so there shouldn't be a problem with the syntax.</p>