Convert raw SQL with comma-JOINed tables to use CodeIgniter's query builder methods

Question

How to write this SQL statement in Active Record?

$this->db->query('
    SELECT a.slogan, a.brief, u.id, u.name
    FROM example_tbl AS a, users AS u
    WHERE u.user_id = "' . USER_ID . '"
');

Answer 1

$this->db->select('a.slogan, a.brief, u.id, u.name')->where('u.user_id', USER_ID)->get('example_tbl AS a, users AS u')->result();

If your selected table fields are not ambiguous you can drop shortcutting like 'AS a, u'...