Trying to join two different IDs with AR

[eluser]jcavard[/eluser]
You are joining twice the same table, but there is no need.
Try this instead...

Code:

$this->db->select('*');
$this->db->from('thug_client_projects p');
$this->db->join('thug_client_groups g', 'g.group_id = p.group_id', 'left');
$this->db->join('thug_client_companies c', 'c.group_id = p.group_id', 'left');
$this->db->get();

I like your table name... I am a thug too