join with multiple conditions

[eluser]bkarat[/eluser]
Hi !

I am new to CodeIgniter. The following query style is working fine in CodeIgniter:

$query=$this->db->query("Select b.INVCODE, b.INVNAME, b.LESSTYPE, a.PROPOSEDAMT, a.INVAMT
from STD b left outer join EMP a
on (b.INVCODE=a.INVCODE) and (a.FINSHORT='$finyear') and
(a.EMPCODE='$user')");

I am not getting the exact syntax to put this in Active Record style. When I use the last two conditions in a where clause, the result is not correct.

Thanks in advance.

With regards,
Bala