Hi,
My model :
return $this->db->query("select a.msisdn , a.status , s.scoring_loan , s.scoring_fee , s.status , s.scoring_tenure , s.validity from accounting a, scoring s where a.msisdn = $msisdn and a.msisdn = s.msisdn;")->result();
I would like to change it to something neat like:
return $this->db->select('select a.msisdn' , 'a.status , s.scoring_loan' , 's.scoring_fee' , 's.status ', 's.scoring_tenure ', 's.validity')->from('accounting a', 'scoring s')->where('a.msisdn = s.msisdn')->where('msisdn', $msisdn)->results();
But it doesn't work.
Is there a way to do multiple select without using join?
Thanks
