Welcome Guest, Not a member yet? Register   Sign In
remove the double quotes of a subquery
#3

(This post was last modified: 12-22-2015, 01:08 AM by andresweb.)

thanks for you help. i'm trying with the next code in the subquery.

$this->db->order_by('u.sem_codigo', 'ASC');
$this->db->order_by('u.udi_letra_nomina','ASC');
$this->db->order_by('m.mat_anio_academico', 'ASC');

equal i have the error.

ERROR: syntax error at or near "AS" LINE 7: ...d"."udi_id" DESC, "m"."mat_anio_academico"" DESC)" AS "mudi" ^

this happens in the subquery. In clausule: "from"

¿how i can remove the quotes doubles of clausule "from"?
Reply


Messages In This Thread
RE: remove the double quotes of a subquery - by andresweb - 12-22-2015, 12:02 AM



Theme © iAndrew 2016 - Forum software by © MyBB