codeigniter活动记录嵌套查询 [英] codeigniter active record nested query
本文介绍了codeigniter活动记录嵌套查询的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!
问题描述
我有一个问题,将下面的MySQL code到A codeigniter活动记录查询。
I'm having a problem converting below MySQL code to a Codeigniter active record query.
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`
我已经试过的建议<一href="http://heybigname.com/2009/09/18/using-$c$c-igniters-active-record-class-to-create-subqueries/"相对=nofollow>此处但没有成功。
推荐答案
你只需要检查的 codeigniter文档
$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');
请报告如有错误
这篇关于codeigniter活动记录嵌套查询的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!
查看全文