Using join

[eluser]Xeoncross[/eluser]
I haven't tried it - but just use several joins.

Code:

$this->db->join('consultants', 'consultants.id = consultants_events.consultant_id');
$this->db->join('events', 'events.id = consultants_events.event_id');
$this->db->join('locations', 'locations.id = events.location_id');

//Fetch
$this->db->get('consultants_events');