title: Symfony2 imbricate sql request
body: <p>I have two objects: Employe and Realisation</p>
  
  <p>In objet Realisation we have attribut employe and type.
  Now , i want to select some employes who made some realisations.</p>
  
  <pre><code>$sql = "SELECT DISTINCT e FROM MonBundle:Employe e WHERE e IN ( SELECT DISTINCT r.employe FROM MonBundle:Realisation r WHERE
  r.type = :type)";
  $query = $em-&gt;createQuery($sql);
  $query-&gt;setParameter("type",$type);
  </code></pre>
  
  <blockquote>
    <p>==>Error: Invalid PathExpression. Must be a StateFieldPathExpression</p>
  </blockquote>