title: NOT IN for multi field DQL Doctrine2
body: <p>I just want to know how to do something like this in doctrine2</p>
  
  <pre><code>select 
      e 
  from 
      \Entity e 
  where 
      e.field1, e.field2 NOT IN (select e2.field1, e2.field2 from \Entity e2 where condition )
  </code></pre>
  
  <p>When I do this or I surround the two fields with parenthesis I got an error like:</p>
  
  <blockquote>
    <p>QueryException: [Syntax Error] line 0, col 136: Error: Expected
    Doctrine\ORM\Query\Lexer::T_CLOSE_PARENTHESIS, got ','</p>
  </blockquote>
  
  <p>or:</p>
  
  <blockquote>
    <p>QueryException: [Syntax Error] line 0, col 135: Error: Expected =, &lt;,
    &lt;=, &lt;>, >, >=, !=, got ','</p>
  </blockquote>
  
  <p>PHP code:</p>
  
  <pre><code>$query = $this-&gt;_em-&gt;createQuery('
    SELECT r FROM LibrairieBundle\Entity\Reseau r 
    WHERE ( r.client1 = :me or r.client2 = :me ) and r.confirme = 1 
    and (r.client2, r.client1) not in (
      select s.clientFrom, s.clientObject from LibrairieBundle\Entity\SuggestClient s 
      where s.clientTo = :cible 
    )
  ');
  </code></pre>