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