Login Register

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

1	`$builder->leftJoin('Robots',` `'r.id = RobotsParts.robots_id',` `'r');`

Links:

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

doc_Phalcon

2025-01-10 15:47:30

Comments

Leave a Comment

Please login to continue.

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::setDI public setDI (Phalcon\DiInterface $dependencyInjector) Sets the DependencyInjector container

Mvc\Model\Query\Builder::orderBy public Phalcon\Mvc\Model\Query\Builder orderBy (string | array $orderBy) Sets an ORDER BY condition clause $builder->orderBy('Robots.name'); $buil

Mvc\Model\Query\Builder::having public having (mixed $having) Sets a HAVING condition clause. You need to escape PHQL reserved words using [ and ] delimiters $builder->having('SU

Mvc\Model\Query\Builder::getDistinct public getDistinct () Returns SELECT DISTINCT / SELECT ALL flag