Mvc\Model\Query\Builder::innerJoin

public Phalcon\Mvc\Model\Query\Builder innerJoin (string $model, [string $conditions], [string $alias])

Adds an INNER join to the query

// Inner Join model 'Robots' with automatic conditions and alias
$builder->innerJoin('Robots');
 
  // Inner Join model 'Robots' specifing conditions
$builder->innerJoin('Robots', 'Robots.id = RobotsParts.robots_id');
 
  // Inner Join model 'Robots' specifing conditions and alias
$builder->innerJoin('Robots', 'r.id = RobotsParts.robots_id', 'r');

Links:

https://docs.phalconphp.com/en/latest/api/Phalcon_Mvc_Model_Query_Builder.html#innerjoin

doc_Phalcon

2025-01-10 15:47:30

Comments

Popular Articles

Mvc\Model\Query\Builder implements Phalcon\Mvc\Model\Query\BuilderInterface, Phalcon\Di\InjectionAwareInterface Source on GitHub Helps to create PHQL queries using an OO int

Mvc\Model\Query\Builder::leftJoin public Phalcon\Mvc\Model\Query\Builder leftJoin (string $model, [string $conditions], [string $alias]) Adds a LEFT join to the query $builder->lef

Mvc\Model\Query\Builder::betweenWhere public betweenWhere (mixed $expr, mixed $minimum, mixed $maximum, [mixed $operator]) Appends a BETWEEN condition to the current conditions $builder-&

Mvc\Model\Query\Builder::from public from (mixed $models) Sets the models who makes part of the query $builder->from('Robots'); $builder->from(array('Robots', 'RobotsParts')

Mvc\Model\Query\Builder::getHaving public string | array getHaving () Return the current having clause