title: LIMITing an SQL JOIN
body: <p>I am trying to limit the following SQL statement.</p>
  
  <pre><code>SELECT expense.*, transaction.* FROM expense
  INNER JOIN transaction ON expense_id = transaction_expense_id
  </code></pre>
  
  <p>What I want to do, is limit the number of 'parent' rows. IE. if I do a LIMIT 1, I would receive only one expense item, but still get all transactions associated with it.</p>
  
  <p>How would this be achieved?</p>
  
  <p>At this stage, if I do LIMIT 1, I get one expense, and only one transaction.</p>