public Phalcon\Mvc\Model\Query\Builder join (string $model, [string $conditions], [string $alias], [string $type])
Adds an INNER join to the query
1 2 3 4 5 6 7 8 9 10 11 | // Inner Join model 'Robots' with automatic conditions and alias$builder->join('Robots'); // Inner Join model 'Robots' specifing conditions$builder->join('Robots', 'Robots.id = RobotsParts.robots_id'); // Inner Join model 'Robots' specifing conditions and alias$builder->join('Robots', 'r.id = RobotsParts.robots_id', 'r'); // Left Join model 'Robots' specifing conditions, alias and type of join$builder->join('Robots', 'r.id = RobotsParts.robots_id', 'r', 'LEFT'); |
Please login to continue.