title: MySQL query for not exists in another table
body: <p>I have two MySQL Tables...</p>
  
  <pre><code>1. master_fee
  2. fees_receiving_ledger
  </code></pre>
  
  <p>I do not want to show the <code>FeeId</code> containing <code>FeeFrequencyId : 4</code> from <code>master_fee</code> table if they are present in <code>fees_receiving_ledger</code> table. </p>
  
  <p><a href="https://i.stack.imgur.com/of4ED.jpg" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/of4ED.jpg" alt="table description"></a></p>
  
  <p>Like above I do not want to show the <strong>Admission Fee</strong> <code>(FeeId:1)</code> containing <code>FrequencyId : 4</code> as it is present in <strong>fees_receiving_ledger</strong>.</p>
  
  <p>I have tried like below...</p>
  
  <pre><code>Select
    master_fee.*
  From
    master_fee
  Where Not Exists(Select
      fees_receiving_ledger.FeeId
  From
      fees_receiving_ledger
  Where
      fees_receiving_ledger.FrequencyId = '4')
  </code></pre>
  
  <p>My query giving me blank result.</p>
  
  <p>I tried <a href="https://stackoverflow.com/questions/17462616/mysql-optimized-query-for-not-in">This</a> but failed.</p>
  
  <p>What should be the query ?</p>
  
  <p>I am using <code>VB.NET</code> with <code>MySQL</code> database.</p>