Defines a table LEFT join to be performed for the query

@param   string  $table     The table join
@param   string  $leftKey   The left side of the join condition
@param   string  $rightKey  The right side of the join condition
@return  $this
432828
public function leftJoin($table, $leftKey, $rightKey)
	{
		$this->syntax->setJoin($table, $leftKey, $rightKey, 'left');
		return $this;
	}
1326741
public function leftJoinOn($table, $on)
    {
        $instance = $this->joinStrategyInstance();

        $instance->joinStrategy()->leftJoinOn($table, $on);

        return $instance;
    }
1150829
protected function _sql_left_join($skey, $sTable, $fkey, $fTable) {
		if (is_array($fTable))
			list($fTable,$fTable_alias) = $fTable;
		$skey = $this->db->quotekey($skey);
		$sTable = $this->db->quotekey($sTable);
		$fkey = $this->db->quotekey($fkey);
		$fTable = $this->db->quotekey($fTable);
		if (isset($fTable_alias)) {
			$fTable_alias = $this->db->quotekey($fTable_alias);
			return 'LEFT JOIN '.$fTable.' AS '.$fTable_alias.' ON '.$sTable.'.'.$skey.' = '.$fTable_alias.'.'.$fkey;
		} else
			return 'LEFT JOIN '.$fTable.' ON '.$sTable.'.'.$skey.' = '.$fTable.'.'.$fkey;
	}
764209
function LeftJoin(Table $table, Condition $condition, $prepend = false)
    {
        return $this->Join($table, JoinType::Left(), $condition, $prepend);
    }
1041696
public function innerJoinOn($table, $where)
    {
        $where = func_get_args();
        $table = array_shift($where);

        $this->join[] = [self::INNER, $table, $where, false];

        return $this;
    }
1336397
public function addForeignKey($name, $table, $key)
    {
        $this->addKeys[$name] = [$table, $key];
        return $this;
    }
1289171
public function between($key, $left, $right)
    {
        $this->resetWhere();
        $this->where($key);
        $this->setTokenValues('Between', array($left, $right));

        return $this;
    }
1356331
public function rightJoin($table, ...$criterion): self
    {
        $this->join[] = $this->joinArgumentsToJoinObject('RIGHT', $table, $criterion);
        return $this;
    }
758720
public function rightJoin($table, Closure $closure)
    {
        $this->sql->addJoinClause('RIGHT', $table, $closure);
        return $this;
    }
1188041
public function rightJoinUsing($table, $where)
    {
        $where = func_get_args();
        $table = array_shift($where);

        $this->join[] = [self::RIGHT, $table, $where, true];

        return $this;
    }
816201
public function leftJoinTo($source, $table, string $on = null, string ...$params)
    {
        $instance = $this->joinStrategyInstance();

        $instance->joinStrategy()->leftJoinTo($source, $table, $on, ...$params);

        return $instance;
    }
375217
public function leftJoin($table, $column1 = null, $operator = null, $column2 = null)
	{
		return $this->join($table, $column1, $operator, $column2, 'LEFT OUTER');
	}
1149088
public function addForeignKey($name, $table, $key)
    {
        $this->keys[$name] = [$table, $key];
        return $this;
    }
1201272
public function leftJoinOn($table, $where)
    {
        //argument test
        Argument::i()
            //Argument 1 must be a string
            ->test(1, 'string')
            //Argument 2 must be a string
            ->test(2, 'string');
        
        $where = func_get_args();
        $table = array_shift($where);
        
        $this->join[] = array(self::LEFT, $table, $where, false);
        
        return $this;
    }
360769
private function setKeyForTable($table, $key)
    {
        $this->validateTableName($table);
        $this->validateKeyName($key);
        $this->tableKeys[$table] = $key;
    }
1147614
public function rightJoin($table, $where, $using = true)
    {
        return $this->join('RIGHT', $table, $where, $using);
    }
217900
public function leftJoin($table, $where, $using = true)
    {
        return $this->join('LEFT', $table, $where, $using);
    }