Active Records SQL join 4 tables help revise code

[eluser]toopay[/eluser]

Code:

$query = $this->db->select('me.* , mwn.* , mwr.*')
                  ->from('member AS me, meetingwhen as mwn, meetingwhere as mwr')
                  ->where('me.member_id = mwn.member_id AND me.member_id = mwr.member_id')
                  ->order_by('me.member_id', 'desc')
                  ->limit(1)
                  ->get();
return $query->result_array();