How to join unrelated entities in QueryBuilder?

Question

Doctrine ORM

An elementary request, with which, for some reason, difficulties arose.

So, there are two entities (tables) that are not related to each other (there is no foreign key):





You need to build a query like this through createQueryBuilder:

SELECT post.title, view.views FROM post
JOIN view ON post.title = view.post
WHERE view.views > 0;

Writing:

public function getPosts(): array
    {
        return $this->createQueryBuilder('p')
            ->join(View::class, 'v', 'ON', 'p.title = v.post')
            ->where('v.views > 0')
            ->getQuery()
            ->getResult()
            ;
    }

I am getting an error:

QueryException: [Syntax Error] line 0, col 61: Error: Expected end of string, got 'ON'

If the entities are interconnected through a property, then there are no problems to join. But is it really necessary to first bind entities through a property in order to then make the necessary join in the QueryBuilder?

Answer 1

return $this->createQueryBuilder('p')
    ->join(View::class, 'v', 'WITH', 'p.title = v.post')
    ->where('v.views > 0')
    ->getQuery()
    ->getResult()
;

Answer 2

It is possible to try to make through raw sql.
But in general, logically, these entities should be connected. Firstly, infa is duplicated in vain, and secondly, violating the consistency of the database is as easy as shelling pears.