title: Symfony 2 query builder join without relation (cross join)
body: <p>I am trying to use the query builder to join 2 tables which have no relation.</p>
  
  <p>Desired end result:</p>
  
  <pre><code>SELECT x, y
  FROM x
  JOIN y
  </code></pre>
  
  <p>Query builder code:</p>
  
  <pre><code>$qb = $this-&gt;getEntityManager()-&gt;createQueryBuilder();
  $qb-&gt;select('x');
  $qb-&gt;from('Test1', 'x');
  $qb-&gt;join('Test2', 'y');
  $qb-&gt;orderBy('x.name', 'ASC');
  </code></pre>
  
  <p>Produces the following DQL:</p>
  
  <p><code>SELECT x FROM Test1 x INNER JOIN Test2 y ORDER BY x.name ASC</code></p>
  
  <p>Which results in a syntax error:</p>
  
  <p><code>[Syntax Error] line 0, col 137: Error: Expected Literal, got 'BY'</code></p>
  
  <p>The entities Test1 and Test2 don't have a relation (not in the code, nor in the database).</p>
  
  <p>Is there any way to accomplish this?
  I would like to use the query builder, because I have a lot of other functionality for the query that depends on the query builder (for filtering and sorting etc.).</p>
  
  <p>I know this is possible with plain SQL, or DQL queries (not produced by the query builder).</p>