Delete with Join or Where_in not working

1. You should do inner join in this case instead of left join (unless $profile_id can be null).
2. In MySQL if you specifying alias for table name you should use alias in delete statement not a table name.
So try this: 

PHP Code:

public function delete_service($location_id,$service_id,$profile_id)
{
    $this->db->from('service s');
    $this->db->join('location l', 's.location_id = l.location_id');
    $this->db->where('s.service_id', $service_id);
    $this->db->where('s.location_id', $location_id);
    $this->db->where('l.profile_id', $profile_id);

    return $this->db->delete('s');
} 


Thanks for your replay, I tried but seems join is ignored in final query. Don't working.

---

@nicolas33770,

With query binding you can do any query and it will work.  I prefer it because it more or less goes directly to the db.  I have very strong db skills so I prefer it over having the framework build it for me.

Yes of course. Thank you.