join with multiple conditions

[eluser]darkhouse[/eluser]
Looks like you need to escape your quotes, or just use double quotes to wrap your statements. Try this.

Code:

$this->db->join("EMP a", "(b.INVCODE=a.INVCODE) and (a.FINSHORT='$finyear') and (a.EMPCODE='$user')", "left outer");