How to implement JOIN in phalcon ORM

Question

How to implement JOIN in phalcon ORM

Amal Apr '13

Created Apr '13	Last Reply Apr '13	Replies 1	Views 1452	Votes 1

Amal 1.4k

Apr '13

How can we implement join queries in phalcon ORM without using direct PHQL queries.

1

Phalcon · Answer 1 · 2013-04-24T07:33:42-07:00

You can use the QueryBuilder:

$robots = $this->modelsManager->createBuilder()
    ->from('Robots')
    ->join('RobotsParts')
    ->order('Robots.name')
    ->getQuery()
    ->execute();

https://docs.phalcon.io/en/1.1.0/reference/phql.html#creating-queries-using-the-query-builder