mysql - Doctrine DQL - 预期字符串结尾，得到 'inner'

Question

我正在尝试执行一些简单的查询，但我总是遇到此异常

[Syntax Error] line 0, col 157: Error: Expected end of string, got 'inner'

这是我的查询:

public function hasRecord($user, $event)
{
    $q = $this->getEntityManager()->createQuery("
                select count(h.id) from Tsk\FEBundle\Entity\History h
                inner join h.user u where u.id = :user
                inner join h.event v and v.id = :event
            ");

    $q->setParameters([
        "user" => $user,
        "event" => $event
    ]);
    return $q->getSingleScalarResult();
}

如何执行两个内部联接？我的查询有问题吗？

Answer 1

您应该在 where 子句之前进行连接:

public function hasRecord($user, $event)
{
    $q = $this->getEntityManager()->createQuery("
                select count(h.id) from Tsk\FEBundle\Entity\History h
                inner join h.user u
                inner join h.event v
                where u.id = :user
                and v.id = :event
            ");

    $q->setParameters([
        "user" => $user,
        "event" => $event
    ]);
    return $q->getSingleScalarResult();
}