Buscar 
Página: 1 de 1  Registros: 346

MySQL error 1054

Unknown column 'PMEtable0.' in 'order clause'

phpMyEdit error: invalid SQL query


SELECT `PMEtable0`.`id` AS `qf0`,`PMEtable0`.`clave` AS `qf1`,`PMEtable0`.`raz_social` AS `qf2`,`PMEtable0`.`observacion` AS `qf3`,`PMEtable0`.`tel` AS `qf4`,CONCAT(IFNULL(CAST(`PMEjoin5`.`nombre` AS CHAR),"")," ",IFNULL(CAST(`PMEjoin5`.`paterno` AS CHAR),"")," ",IFNULL(CAST(`PMEjoin5`.`materno` AS CHAR),"")," ") AS `qf5`,CONCAT(TRIM(PMEjoin5.nombre) , " " ,TRIM(PMEjoin5.materno), " ",TRIM(PMEjoin5.paterno)) AS `qf5_idx`,`PMEtable0`.`cat_vigencia` AS `qf6`,UNIX_TIMESTAMP(`PMEtable0`.`cat_vigencia`) AS `qf6_timestamp` FROM `v_procredencial4` AS `PMEtable0` LEFT OUTER JOIN `procontactos` AS `PMEjoin5` ON (`PMEtable0`.id = PMEjoin5.id_proveedor AND PMEjoin5.tipo=1 ) ORDER BY `PMEtable0`.``,`PMEtable0`.`id` DESC LIMIT 0, 1000
INFO ID Registro UNAM Empresa Giro Telefonos Representante Fecha vigencia