codeigniter活动记录嵌套查询
codeigniter活动记录嵌套查询
提问于 2013-03-29 21:14:21
我在将下面的MySQL代码转换为Codeigniter活动记录查询时遇到问题。
SELECT sss.*, c.country_name, c.country_code
FROM ( SELECT gr.*
FROM (`be_goldrate` as `gr`)
WHERE `gr`.`country_id` != 0
AND `gr`.`rate_type` = 'calculated'
ORDER BY gr.date DESC ) as sss
LEFT JOIN `be_countries` as `c`
ON `c`.`country_id`=`sss`.`country_id`
GROUP BY `sss`.`country_id`我尝试过建议的here，但没有成功。
Stack Overflow用户
发布于 2013-03-30 00:31:56
您只需检查Codeigniter Documentation
$this->db->select('sss.*, c.country_name, c.country_code ');
$this->db->from('(SELECT gr.*
FROM (`be_goldrate` as `gr`)
WHERE `gr`.`country_id` != 0
AND `gr`.`rate_type` = "calculated"
ORDER BY gr.date DESC) as sss');
$this->db->join('be_countries as c','c.country_id = sss.country_id','left');
$this->db->group_by('sss.country_id'); 如果有任何错误，请报告
页面原文内容由Stack Overflow提供。腾讯云小微IT领域专用引擎提供翻译支持
原文链接：
https://stackoverflow.com/questions/15703992
复制相关文章
相似问题
腾讯云开发者
