title: doctrine join without relation
body: <blockquote>
    <p><strong>Possible Duplicate:</strong><br>
    <a href="https://stackoverflow.com/questions/2203027/is-this-possible-to-join-tables-in-doctrine-orm-without-using-relations">Is this possible to join tables in doctrine ORM without using relations?</a>  </p>
  </blockquote>
  
  
  
  <p>I have 2 classes Month and Vegetable. They don't have any relation together.</p>
  
  <p>I would like to play the SQL :
  <code>SELECT * FROM month, vegetable</code></p>
  
  <p>In MySQL it works perfectly. I try it like that in Doctrine:</p>
  
  <pre><code>    $months = Doctrine_Query::create()
        -&gt;select('m.*, v.*')
        -&gt;from('month m, vegetable v')
        -&gt;execute();
  </code></pre>
  
  <p>When I try it, I get :</p>
  
  <pre><code>"vegetable" with an alias of "v" in your query does not reference the parent component it is related to.
  </code></pre>
  
  <p>Does anyone know why ?</p>
  
  <p>Is it possible to make what I want with doctrine ?</p>