UNION query with codeigniter's active record pattern

Question

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

Answer 1

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');