title: MySQL Workbench - How to get results from multiple where clauses?
body: <p>I am trying to pull institution names that has a relation to one or more custodians. </p>
  
  <p>For example, let's say Institution A is has a relation to Custodian 1, 2, and 3 then I want the result to show only Institution A, NOT Institution B and C. Basically I only want to see the institutions that has Custodian 1,2,3, NOT the institutions that has a relationship to only Custodian 1 or 2 or 3. </p>
  
  <p>(Hope the question makes somewhat sense)</p>
  
  <p>Below is the SQL that I am working on:</p>
  
  <pre><code>select i.institution_name, custodian_name
  from institution i
  join institution_has_custodian ihcu
  on i.institution_id = ihcu.institution_id
  join custodian c
  on c.custodian_id = ihcu.custodian_id
  where c.custodian_name in ('JPMorgan (00902/82D)','BNY Mellon (Formerly Bony) (00901/93I)')
  </code></pre>