title: MySql Query with multiple condition
body: <p>I have two tables </p>
  
  <pre><code>1) Student
  
   id   |   Student_name
  --------------------
   1    |   John
   2    |   Joy
   3    |   Raju
  
  2) Category
  
   id    |  category_name
  -------------------------
   1     |  Maths Fest
   2     |  Science Fest
   3     |  IT Fest
   4     |  English Fest
   5     |  Cultural Fest
  
  3) Student_category
  
    id   | student_id  | category_id
   ------------------------------------
    1    |    1        |     4
    2    |    1        |     5
    3    |    1        |     1
    4    |    2        |     1
    5    |    2        |     4
    6    |    3        |     1
    7    |    3        |     5
    8    |    3        |     3
  </code></pre>
  
  <p>I need to write a query to select students who have participate in both Maths fest &amp; English Fest. </p>
  
  <p>i used this query </p>
  
  <pre><code>SELECT distinct student_name 
  FROM student A,student_category B 
  WHERE A.id=B.student_id 
    and B.category_id IN ('1','4')
  </code></pre>
  
  <p>but it give result student who participate in  Maths fest OR English Fest. 
  please help me</p>