title: How to write a query for selecting from three tables and if the values are null should not select?
body: <p>I have three tables
  1) Category_master</p>
  
  <pre><code> CID     CTYPE
  ---------------------
    1       2  
  --------------------
    2       2
  --------------------
    3       1
  -------------------
    4       3
  ----------------
    5       2
  -------------------
    6       3
  </code></pre>
  
  <p>2) NSS_maste</p>
  
  <pre><code>NID    MID    Name      Value
  </code></pre>
  
  <hr>
  
  <pre><code> 1       5     Red        86
  </code></pre>
  
  <hr>
  
  <pre><code> 2       1     Blue       96
  </code></pre>
  
  <p>3) Sports_master</p>
  
  <pre><code> SID   MID    Name      Cat
  </code></pre>
  
  <hr>
  
  <pre><code>  1     4     Walk      Leg
  </code></pre>
  
  <p>The above is my table </p>
  
  <p>I have to select CTYPE, NSS.NAME NSS.value,sports.name, sports.cat from category master,NSS_master and sports_master an it should not select null value Eg: for CID 2 there is no value in NSS_master table so it should not select but for CID 3 CTYPE 1 select name and other values as null </p>
  
  <p>How to implement this thank you </p>