Help building a query using ActiveRecord

[eluser]cahva[/eluser]
This can be done with AR no problemo:

Code:

$q = $this->db->select("CONCAT(u.user_first_name,' ',u.user_last_name) User,a.account_numb Account,s.state State",FALSE)
    ->join('Accounts a','u.user_id=a.user_id','inner')
    ->join('States s','u.state_id=s.state_id','inner');

$q->get('Users u')->result();

I left out AS (the alias). It is not used by some DBMS(at the time) so I left it out couple of years ago.