Mvc\Model\Criteria::innerJoin

public innerJoin (mixed $model, [mixed $conditions], [mixed $alias])

Adds an INNER join to the query

$criteria->innerJoin('Robots');
$criteria->innerJoin('Robots', 'r.id = RobotsParts.robots_id');
$criteria->innerJoin('Robots', 'r.id = RobotsParts.robots_id', 'r');

Links:

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

doc_Phalcon

2016-10-16 09:53:11

Comments

Popular Articles

Mvc\Model\Criteria implements Phalcon\Mvc\Model\CriteriaInterface, Phalcon\Di\InjectionAwareInterface Source on GitHub This class is used to build the array parameter r

Mvc\Model\Criteria::setDI public setDI (Phalcon\DiInterface $dependencyInjector) Sets the DependencyInjector container

Mvc\Model\Criteria::sharedLock public sharedLock ([mixed $sharedLock]) Adds the “shared_lock” parameter to the criteria

Mvc\Model\Criteria::orderBy public orderBy (mixed $orderColumns) Adds the order-by clause to the criteria

Mvc\Model\Criteria::where public where (mixed $conditions, [mixed $bindParams], [mixed $bindTypes]) Sets the conditions parameter in the criteria