How do you do Active Record joins on multiple fields

[eluser]rainman[/eluser]
Thanks guys!
Worked for me. I'm able to join on multiple fields using the "AND" as the separator.

$this->db->join('table1', 'table1.field1 = table2.field1 AND table1.field2 = table2.field2'); <-- Then of course using the left join as the 3rd parameter if needed.

[eluser]Unknown[/eluser]
- never mind, pls ignore this post -