title: LEFT OUTER JOIN MySQL query returns empty result set
body: <p>I have 2 tables: <strong>s_master</strong>  and <strong>p_master</strong> . </p>
  
  <p><strong>S_master table</strong></p>
  
  <pre><code>s_id   form_id
  ----   -------
    1     kit011
    2     kit011
    3     kit011
    4     kit011
    5     kit011
  </code></pre>
  
  <p><strong>p_master table</strong></p>
  
  <pre><code>s_id   staus
  ----   -------
    2     1
    3     2
    4     1
  </code></pre>
  
  <p>Problem statement:</p>
  
  <p>I have to fetch <strong>s_id</strong> from <strong>s_master</strong> table which are <strong>NOT</strong> having status <strong>1</strong> in <strong>p_master</strong> table. That means I need to fetch <strong>1,3,5</strong>  .</p>
  
  <p>For this I have used following query.</p>
  
  <pre><code>SELECT a.s_id FROM s_master a 
    left outer join p_master b on a.s_id!=b.s_id 
   where  b.status=1 and a.form_id='kit011';
  </code></pre>
  
  <p>But it shows "Empty result set" as result.</p>
  
  <p>Kindly suggest me the query . Thanks in advance.</p>