[Solved] Active record join problem.

[eluser]Doosje[/eluser]

Code:

$this->db->select('user.username as author, user.username as last_msg_by')
->join('user_users as user', 'user.id = forums_threads.ID_MEMBER_STARTED', "left")
->join('user_users as users', 'users.id = forums_threads.ID_MEMBER_UPDATED', "left")

try this ..