怎么办UNION查询与codeigniter框架的活动记录查询的格式？

How to do UNION query with codeigniter framework's active record query format?

推荐答案

codeIgniter的ActiveRecord的不支持UNION，所以你只写你的查询和使用的ActiveRecord的查询方法。

CodeIgniter's ActiveRecord doesn't support UNION, so you would just write your query and use the ActiveRecord's query method.

$this->db->query('SELECT column_name(s) FROM table_name1 UNION SELECT column_name(s) FROM table_name2');