Trying to join two different IDs with AR

[eluser]spmckee[/eluser]
Sweet!

Had to switch a few of the names but in the end all is well. Good to meet a fellow Thug

Code:

$this->db->join('thug_client_groups g', 'g.group_id = p.group_id', 'left');
$this->db->join('thug_client_companies c', 'c.company_id = p.company_id', 'left');