RE: Concatenar Field's

2004-07-06 Thread Victor Pendleton
Ud necesista usar, CONCAT(tabla_manzan.CODUGIGEO, table_manaza.CODCCPP99) AS IDCCPP o si Ud quiere un espacio CONCAT_WS(' ', tabla_manzan.CODUGIGEO, table_manaza.CODCCPP99) AS IDCCPP -Original Message- From: Wilder Castelo To: [EMAIL PROTECTED] Sent: 7/6/04 3:08 PM Subject:

Concatenar Field's

2004-07-06 Thread Wilder Castelo
Estoy teniendo un problema cuando ejecuto esta sentencia. SELECT Sum(tabla_manzana.TOTPOB) AS POBLACION, Sum(tabla_manzana.TOTVIVIEN) AS VIVIENDA, tabla_manzana.CODUBIGEO & tabla_manzana.CODCCPP99 AS IDCCPP, tabla_manzana.NOMCCPP99 FROM tabla_manzana GROUP BY tabla_manzana.CODUBIGEO, tabla_manzana