multiple table select

I would prefer the join statement:

PHP Code:

$this->db
->select('a.*,s.scoring_tenure,s_validity')
->from('accounting a')
->join('scoring s','a.msisdn = s.msisdn')
->where('a.msisdn',$msisdn);
return $this->db->get()->result();