[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