Welcome Guest, Not a member yet? Register   Sign In
Help with RIGHT JOIN conversion?
#1

MySQL query is as follows:

Code:
SELECT RossResearchDB.property.id, RossResearchDB.property.lat, RossResearchDB.property.long, RossResearchDB.property.property_name, RossResearchDB.liked_property.FK_Renter FROM RossResearchDB.liked_property right join RossResearchDB.property
on RossResearchDB.liked_property.FK_Property = RossResearchDB.property.id
and FK_Renter = 2;

I am lost on how to set this up using the CI syntax.

Any help on the way ahead is appreciated!

Ross
Reply


Messages In This Thread
Help with RIGHT JOIN conversion? - by nfoboy - 01-21-2020, 08:40 PM
RE: Help with RIGHT JOIN conversion? - by nfoboy - 01-21-2020, 09:22 PM
RE: Help with RIGHT JOIN conversion? - by nfoboy - 01-22-2020, 11:07 AM
RE: Help with RIGHT JOIN conversion? - by nfoboy - 01-22-2020, 11:08 AM
RE: Help with RIGHT JOIN conversion? - by nfoboy - 01-22-2020, 09:30 PM



Theme © iAndrew 2016 - Forum software by © MyBB