HOw do I write this join correctly using CI

[eluser]Seppo[/eluser]
If you want to use ActiveRecord

Code:

$this->db->select('contractors.lname, contractors.fname, jobs.position, clients.companyName, jobs.current');
$this->db->from('jobs');
$this->db->join('contractors', 'jobs.contractor_id = contractors.id', 'inner');
$this->db->join('clients', 'jobs.company_id = clients.id', 'inner');
$this->db->where('jobs.current', 'Yes');
$query = $this->db->get();