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

I have this figured out so far: (shortened my requested fields until I get this figured out)

Code:
$this->db->select('property.id , property.lat, liked_property.FK_Property');
$this->db->from('property');
$this->db->join('liked_property', 'liked_property.FK_Property = property.id', 'left');
$this->db->where('liked_property.FK_Renter', 2);

except that "where" is not giving me the AND portion...  I get 

SELECT `property`.`id`, `property`.`lat`, `liked_property`.`FK_Property` FROM `property` LEFT JOIN `liked_property` ON `liked_property`.`FK_Property` = `property`.`id` WHERE `liked_property`.`FK_Renter` = 2
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