I have join between hierarchical entities:

A and A1 , A2 (A is parent of A1 and A2)
B and B1 ,B2 (B is parent of B1 and B2)
A ha a relation with B
B2 has a Relation with C

I'd like to join A2,B2,C:
SELECT....
FROM A2 a2 LEFT JOIN a2.B b
LEFT JOIN b.C c <---- I CAN NOT DO THAT!


or I'd like to join A2,B2,C:
SELECT....
FROM A2 a2 LEFT JOIN a2.B2 b2
LEFT JOIN b2.C c <---- I CAN NOT DO THAT!


how can I write a DQL through A1 -> A -> B ->B2 -> C ?
How can I obtain (By DQL) C entities related with A1 through the chain : A1 -> A -> B ->B2 -> C ? or A1 -> B2 -> C ?

Thank you in advance,
Oda

--
You received this message because you are subscribed to the Google Groups 
"doctrine-user" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to [email protected].
To post to this group, send email to [email protected].
Visit this group at https://groups.google.com/group/doctrine-user.
For more options, visit https://groups.google.com/d/optout.

Reply via email to