HOw do I write this join correctly using CI

[eluser]mironcho[/eluser]
Try something like this:

Code:

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