I have some code (works):
$q = Doctrine_Query::create()
->from('UsersProjects up')
->innerJoin('up.Users u');
Two questions:
Could sombody show me an example, how to join next table (more then one)? Doctrine's documentation contains only basic examples... :-(
Can I use
innerJoin()
with any table from my db (eg. Usertypes related with Users) or only with table related with UsersProjects (in this case: Projects and Users)? When I trying to do it then I get error "Unknown relation".