join with multiple conditions

join with multiple conditions

El Forum
Unregistered

02-24-2009, 11:53 PM

[eluser]darkhouse[/eluser]
That's because you don't have a where clause to begin with. Just put "(b.INVCODE=a.INVCODE) and (a.FINSHORT=’$finyear’) and (a.EMPCODE=’$user’)" in the second parameter of your $this->db->join();

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