I'd assume this is a JOIN question...

[eluser]Dam1an[/eluser]
You didnlt state if you're using AR or plain SQL, so I'll assume the former

Code:

$this->db->join('event_types', 'events.event_type_id = event_types.event_type_id');
$query = $this->db->get('events');

You can obvioulsy add any other parts to the query, just as selects and aliases, where clauses etc

Hopefully that code makes sense, if not, have a read up on joins, and if still not, then post back and I'll try my best to explain it