如主题!
用ci实现起来就是这样:
$this->db->join('images','medical_package.img_id=images.id','left'); $this->db->join('images i','medical_package.pc_img_id=i.id','left');
原生代码就是
select p.*,a.img_small img_small,b.img_small pc_img_small from package p left join images a on a.id=p.img_id left join images b on b.id=p.pc_img_id