join with multiple conditions

join with multiple conditions

El Forum
Guest

02-25-2009, 12:25 AM

[eluser]bkarat[/eluser]
Thanks for yr reply. I am getting an error on this line -> "Parse error: syntax error, unexpected T_VARIABLE in ....."

My join looks like this now:

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

With regards,
Bala

Messages In This Thread

join with multiple conditions - by El Forum - 02-24-2009, 11:43 PM

join with multiple conditions - by El Forum - 02-24-2009, 11:53 PM

join with multiple conditions - by El Forum - 02-25-2009, 12:25 AM

join with multiple conditions - by El Forum - 02-25-2009, 12:27 AM

join with multiple conditions - by El Forum - 02-25-2009, 12:38 AM

join with multiple conditions - by El Forum - 03-25-2009, 04:08 PM

join with multiple conditions - by El Forum - 03-25-2009, 04:21 PM

join with multiple conditions - by El Forum - 03-25-2009, 08:09 PM

join with multiple conditions - by El Forum - 03-25-2009, 08:16 PM