title: Symfony2 join query
body: <p>I have a table of videos and in that table I have field comment which contains id of comment in other table, now I used join query to get that in one query, but how do I get that comment?</p>
  
  <p>Here is my code:</p>
  
  <pre><code>$Actions = $this-&gt;EntityManager()-&gt;getRepository('AppBundle:Video')
                                      -&gt;createQueryBuilder('V')
                                      -&gt;join('AppBundle:VideoComment', 'VC')
                                      -&gt;where('V.videoId = :VideoID')
                                      -&gt;andWhere('VC.videoId = :VideoID')
                                      -&gt;setParameter('VideoID', $VideoID)
                                      -&gt;getQuery()
                                      -&gt;getResult();
  </code></pre>
  
  <p>How do I get the actual comment from that joined entity?</p>