title: Using Multiple Tables in a Zend Model and returning a combined result set
body: <p>Hi This is either a very specific or very generic quetion - I'm not sure, and I'm new to the Zend framework / oo generally.  Please be patient if this is a stupid Q...</p>
  
  <p>Anyway, I want to create a model which does something like:</p>
  
  <pre><code>Read all the itmes from a table 'gifts' into a row set
  
  for each row in the table, read from a second table which shows how many have been bought, the append this as another "field" in the returned row
  
  return the row set, with the number bought included.
  </code></pre>
  
  <p>Most of the simple Zend examples seem to only use one table in a model, but my reading seems to suggest that I should do most of the work there, rather than in the controller.  If this is too generic a question, any example of a model that works with 2 tables and returns an array would be great!</p>
  
  <p>thanks for your help in advance!</p>