How to join tables to one parent table related by different columns with a MYSQL query in CodeIgniter

Question

How do I write this MySQL query in CodeIgniter?

SELECT *
FROM t1
LEFT JOIN (t2, t3, t4)
ON (t2.a=t1.a AND t3.b=t1.b AND t4.c=t1.c)

Lorenzo Aiello · Accepted Answer · 2013-12-04 05:04:06Z

3

Try this

$this->db->select(*);
$this->db->from('t1');
$this->db->join('t2','t2.a = t1.a','left');
$this->db->join('t3','t3.b = t1.b','left');
$this->db->join('t4','t4.c = t1.c','left');

Alternatively (condensed)

$this->db->select(*)->from('t1')->join('t2','t2.a = t1.a','left')->join('t3','t3.b = t1.b','left')->join('t4','t4.c = t1.c','left');

Reference: http://ellislab.com/codeigniter/user-guide/database/active_record.html

answered Dec 4, 2013 at 5:04

Lorenzo Aiello

4391 gold badge8 silver badges19 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

How to join tables to one parent table related by different columns with a MYSQL query in CodeIgniter

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related