Join Logic

[eluser]ibnclaudius[/eluser]
Ops, fixed:

Code:

$query = $this->db->select($this->_table['events'] . '.id, ' . $this->_table['events'] . '.title, ' . $this->_table['events'] . '.date, ' . $this->_table['users'] . '.username AS user_username, ' . $this->_table['colleges'] . '.username AS college_username', FALSE)
        ->from($this->_table['events'] . ', ' . $this->_table['users_colleges'])
        ->join($this->_table['colleges'], $this->_table['colleges'] . '.id = ' . $this->_table['events'] . '.college_id AND ' . $this->_table['colleges'] . '.id = ' . $this->_table['users_colleges'] . '.college_id', 'INNER')
         ->join($this->_table['users'], $this->_table['users'] . '.id = ' . $this->_table['events'] . '.user_id', 'INNER')
        ->where($this->_table['users_colleges'] . '.user_id', $user_id)
        ->get();