1. Home
  2. ORM

Joins

How can I set the type of JOIN (ex. left or right)?

1


83.4k
$result = $this->modelsManager->query("SELECT * FROM Robots LEFT JOIN RobotsParts");


1.3k

Got "Fatal error: Call to undefined method Phalcon\Mvc\Model\Manager::query()"



83.4k

Sorry, it must be:

$result = $this->modelsManager->executeQuery("SELECT * FROM Robots LEFT JOIN RobotsParts");

http://docs.phalconphp.com/en/1.0.0/reference/phql.html#joins http://docs.phalconphp.com/en/1.0.0/reference/phql.html#creating-queries-using-the-query-builder