Error with complex Oracle query

Code:

$this->db->select("select pu.last_name,

Remove the select, this should just be column names.

Code:

$this->db->select("pu.last_name,