title: MYSQL OR two values on one column
body: <p>I have 2 tables.</p>
  
  <p><strong>Table 1: tA</strong></p>
  
  <pre><code>+----+--------------------+
  | id | url                |
  +----+--------------------+
  | 1  | hxxp://www.aaa.com |
  | 2  | hxxp://www.bbb.com |
  +----+--------------------+
  </code></pre>
  
  <p><strong>Table 2: tB</strong></p>
  
  <pre><code>+----+-------+--------+----------+
  |id  | tA_id | cat_id | cat_name |
  +----+-------+--------+----------+
  | 1  |   1   |    1   |  Mobile  |
  | 2  |   1   |    2   |  Other   |
  | 3  |   2   |    2   |  Other   |
  +----+-------+--------+----------+
  </code></pre>
  
  <p><strong>Expected Output</strong></p>
  
  <pre><code>+----+-------+--------+----------+
  | id | tA_id | cat_id | cat_name |
  +----+-------+--------+----------+
  | 1  |   1   |    1   |   Mobile |
  | 3  |   2   |    2   |   Other  |
  +----+-------+--------+----------+
  </code></pre>
  
  <p><strong>mysql code:</strong></p>
  
  <pre><code>select * 
  from tA 
  inner tB 
  on tA.id = tB.tA_id 
  where tB.cat_id = 1 
  or tB.cat_id = 2 
  Group By tA_id
  </code></pre>
  
  <p><strong>result from my mysql code:</strong></p>
  
  <pre><code>+----+-------+--------+----------+
  | id | tA_id | cat_id | cat_name |
  +----+-------+--------+----------+
  | 1  |   1   |   2    |   Other  |
  | 3  |   2   |   2    |   Other  |
  +----+-------+--------+----------+
  </code></pre>
  
  <p>How do I do?</p>