Login

07-02-2007, 12:03 AM

[eluser]champs[/eluser]
We need a one-size-fits-all solution that works *all* the time, so what happens when each row in the table has multiple relationships to the same table?

Code:
&lt;?php

$this->db->select('s.*, t.name AS teachername, p.name AS parentname');

$this->db->from('student AS s');

$this->db->join('adult AS p', 's.parent=p.personid');

$this->db->join('adult AS t', 's.teacher=t.personid');

?&gt;