title: How to retrieve same column twice with different conditions in same table?
body: <p>This is my  table:</p>
  
  <pre><code>Anganbadi_ID               Food     Month
  -------------------------------------------    
  1165                       हाँ         1
  1165                       हाँ         2
  1165                       हाँ         4
  1168                       हाँ         4
  2032                       नहीं        4
  2218                       नहीं        4
  2219                       हाँ         4
  2358                       नहीं        4
  2546                        हाँ        10 
  </code></pre>
  
  <p>there are 4 columns <code>Anganbadi_ID, Food, Month, Year</code> and I want to compare <code>Food</code> column twice based on two different month values.</p>
  
  <p>e.g. if I select Month=4 for first Food (Food-1) column and Month=10 for second Food (Food-2) column, then it should be like following::</p>
  
  <pre><code>Anganbadi_ID            Food-1     Food-2    
  ------------------------------------------    
  1165                       हाँ          NULL 
  1168                       हाँ          NULL 
  2032                       नहीं        NULL 
  2218                       नहीं        NULL 
  2219                       हाँ          NULL 
  2358                       नहीं        NULL 
  2546                     NULL        हाँ 
  </code></pre>
  
  <p>When I'm trying this code</p>
  
  <pre><code>SELECT     
     Anganbadi_ID, Food,
     (SELECT Food
      FROM Anganbadi AS Anganbadi_2
      WHERE (Anganbadi_1.Anganbadi_ID = Anganbadi_ID) 
        AND (Anganbadi_1.Month = 10)
     ) AS 'Food(2)'
  FROM Anganbadi AS Anganbadi_1
  WHERE (Month = 4)
  </code></pre>
  
  <p>It shows following results::</p>
  
  <pre><code>Anganbadi_ID              Food-1     Food-2    
  --------------------------------------------
  1165                       हाँ          NULL 
  1168                       हाँ          NULL 
  2032                       नहीं        NULL 
  2218                       नहीं        NULL 
  2219                       हाँ          NULL 
  2358                       नहीं        NULL 
  </code></pre>
  
  <p>Please help me as soon as possible....</p>