CODEWITHSUNDEEP
sqlcodeigniterjoin
Kyle
Kyle

Reputation: 99

codeigniter multiple join conditions on same table

Basically i want to join a table where a col in table A matches a col in table B and where a col in table B is equal to 0. I am using codeigniters active record class.

Thanks in advance.

Upvotes: 6

Views: 14221

Answers (1)

Ton van den Heuvel
Ton van den Heuvel

Reputation: 10528

Something like this should work:

$this->db->join('B', 'aCol = bCol AND bOtherCol = 0');
$this->db->get('A');

Optionally, a third argument can be specified for the join method to indicate whether a left or right join should be performed. For example, to perform a left join:

$this->db->join('B', 'aCol = bCol AND bOtherCol = 0', 'left');

Upvotes: 12

Related Questions