加入活跃的记录codeigniter

Question

Would you like to help me? How to change this sql query to active record in codeigniter

LEFT JOIN MGMETADATA.services d ON d.protocol = e.protocol and d.port = e.s_port

Thanks,

Answer 1

please try this

$this->db->select('*');
$this->db->from('tableE');
$this->db->join('tableD','tableD.protocol=tableE.protocol and tableD.port=tableE.s_port','left');
$query = $this->db->get();
return $query->result();

i hope this can help you