Welcome Guest, Not a member yet? Register   Sign In
Left outside Join in Code Igniter
#1

So here's the question: I'm not sure how to write on code igniter; I read an article about it here, thus I want to insert my "And" statement before the where. The query works, but I'm not sure what the syntax is in code igniter. Thank you in advance for any assistance.
Code:
Select c.c_id, c.c_name, p.phone_no FROM Company AS c
LEFT OUTER JOIN Phone AS p
ON p.p_flex_id=c.c_id
AND p.g_id'='1' AND p.ct_id='3'
WHERE 1
Reply


Messages In This Thread
Left outside Join in Code Igniter - by leusiam - 01-23-2023, 05:55 AM



Theme © iAndrew 2016 - Forum software by © MyBB