public function join($mode, $table, $on)
    {
        $this->_join[] = sprintf('%s JOIN %s ON %s', $mode, $table, $on);

        return $this;
    }
public function join($mode, $table, $on)
    {
        $this->_join[] = sprintf('%s JOIN %s ON %s', $mode, $table, $on);

        return $this;
    }
public function join ( $ mode , $ table , $ on ) { $ this -> _join [ ] = sprintf ( '%s JOIN %s ON %s' , $ mode , $ table , $ on ) ; return $ this ; }
Add JOIN clause

@param $mode     string    INNER|LEFT|RIGHT or other mysql join possibilities
@param $table    string    table name
@param $on       string    join condition

@return $this
Add JOIN clause