title: I want to fetch rows in a first table that are not in a second table
body: <p>I have a table, let's call it <code>fees</code>, and two other tables, let's call them <code>transactions</code> and <code>breakdowns</code>.</p>
  
  <p><code>transactions</code> table saves the general summary of payments received while <code>breakdowns</code> table saves the breakdown of the payments.</p>
  
  <p>breakdowns table looks something like this</p>
  
  <pre><code>id | transaction_id | fee_id
  </code></pre>
  
  <p>and fees table looks something like this</p>
  
  <pre><code>id | amount | description
  </code></pre>
  
  <p>I'd like to fetch the fees in fees table that do not have records in breakdowns table based on the transaction_id</p>
  
  <pre><code>SELECT * FROM fees LEFT JOIN breakdowns ON (fees.id = breakdowns.fee_id) 
  WHERE breakdowns.transaction_id = 'xxxxxxxxxxxxxxxxxxxxxxxxxxxxx';
  </code></pre>
  
  <p>The code above returns empty rows</p>