Update / Delete on Joined Tables

What about this?

PHP Code:

public function find_party_user($user_id) {

$this->db->select('something')->from('party_table')
->where('user_id', $user_id);
$where_clause = $this->db->get_compiled_select();

$query = $this->db->delete('character_table', array('some_id' => $where_clause));
} 


get_compiled_select might be the answer for your problem.