Query problem, have to work with joins

Query problem, have to work with joins

El Forum
Guest

06-28-2011, 09:46 PM

[eluser]InsiteFX[/eluser]
Try this, not tested:

Code:
$this->db->join('org_com','companies.id = org_com.com_id', 'left')

     ->where('org_id', $this->session->userdata('user_id'))

     ->get('companies');

InsiteFX

Messages In This Thread

Query problem, have to work with joins - by El Forum - 06-28-2011, 01:53 PM

Query problem, have to work with joins - by El Forum - 06-28-2011, 04:11 PM

Query problem, have to work with joins - by El Forum - 06-28-2011, 04:45 PM

Query problem, have to work with joins - by El Forum - 06-28-2011, 06:02 PM

Query problem, have to work with joins - by El Forum - 06-28-2011, 09:46 PM