MySQL Text field

[eluser]attosolutinos[/eluser]
You are correct. That function does not select the field that is because it is the wrong function. Here is the correct function

$this->db->where(array('memberid'=>$id));
$this->db->join("csa.pickuploc","member.pickupid=pickuploc.pickupid");
$query = $this->db->get("csa.member");
return $query;

I have not tried to build my own query and try that yet. But that is my next step. any other suggestions???