title: Joining two select statements into one with 2 WHERE clauses
body: <p>I'm using these two select statements and want to join them into just one. Does anyone have any suggestions. However, the problem is that I'm using access and the case clause isn't there in access. </p>
  
  <pre><code>SELECT 
       Table_1.Table_Identification_Number,
       AVG (Table_2.Coulmn-2) AS avg_attribute
  FROM 
      Table_1 JOIN
      Table_2 ON Table_1.Table_Identification_Number = Table_2.Table_Identification_Number
  WHERE
      Table_2.Column-3='1'
  GROUP BY 
      Table_1.Table_Identification_Number
  
  
  SELECT 
       Table_1.Table_Identification_Number,
       AVG (Table_2.Coulmn-2) AS avg_attribute
  FROM 
      Table_1 JOIN
      Table_2 ON Table_1.Table_Identification_Number = Table_2.Table_Identification_Number
  WHERE
      Table_2.Column-3='2'
  GROUP BY 
      Table_1.Table_Identification_Number
  </code></pre>