title: combination of having count and column query
body: <p>I have a join table with a combined primary key of two columns. 
  I want to query all entries </p>
  
  <pre><code>columnA having count &gt; 1
  </code></pre>
  
  <p>and  </p>
  
  <pre><code>columnB = value1 and value2
  </code></pre>
  
  <p>my query so far looks like this</p>
  
  <pre><code>select 
    columnA 
  from tableA 
  where columnB = 1 and 
  columnA in (
           select 
             columnA 
           from tableA 
           group by columnA 
           having count(columnA) &gt; 1) 
  </code></pre>
  
  <p>or </p>
  
  <pre><code>select 
        columnA 
      from tableA 
      where columnB = 2 and 
      columnA in (
               select 
                 columnA 
               from tableA 
               group by columnA 
               having count(columnA) &gt; 1) 
  </code></pre>
  
  <p>how can i query </p>
  
  <pre><code>...columnB = 1 and columnB = 2 and columnA in (select ....
  </code></pre>