$sb = new Select();
$sb
->select('u.name')
->from('users', 'u')
->leftJoin('u', 'phone', 'p', 'p.is_primary = 1');
|
public leftJoin ( string $fromAlias, string $join, string $alias, string $condition = null ) : |
||
| $fromAlias | string | the alias that points to a from clause |
| $join | string | the table name to join |
| $alias | string | the alias of the join table |
| $condition | string | the condition for the join |
| return | instance | |
public function leftJoin($fromAlias, $join, $alias, $condition = null)
{
$this->aliases[] = $alias;
return $this->addQueryPart('join', [$fromAlias => ['joinType' => 'left', 'joinTable' => $join, 'joinAlias' => $alias, 'joinCondition' => $condition]], true);
}