I am not sure exactly how one properly specifies what the ``from``. left/right join are not the same thing than in normal SQL, that part is sure .. I stumbled on this point also when I was fixing join support in the Doctrine DBAL QOMWalker.