It's a table Isabel Bedoya Gómez Gestión de Tecnología Tel. 2307500 ext: 4077 Wolfgang Breitling <breitliw@centrex Para cc.com> crcbedoy@xxxxxxxxxxxxxxxxx Enviado por: cc oracle-l-bounce@f oracle-l@xxxxxxxxxxxxx reelists.org Asunto Re: Query in 10g 08/11/2006 10:46 Por favor, responda a breitliw@centrexc c.com Is VRH_PRO_ACU_COL_PAG a table or a view? At 08:40 AM 11/8/2006, crcbedoy@xxxxxxxxxxxxxxxxx wrote: The same error message:(:(.. It´s gonna make me crazy!:(:( [][] and what if you omit the concatination part? select ACUM_PERIODO,con_nombre, pec_saldo_valor, acum_valor_local from VRH_PRO_ACU_COL_PAG WHERE emp_codigo = '43103973' and ACUM_ANO = 2006 and acum_mes=9 / Regards Wolfgang Breitling Centrex Consulting Corporation www.centrexcc.com ______________________________________________________________________ This email has been scanned by the MessageLabs Email Security System. For more information please visit http://www.messagelabs.com/email ______________________________________________________________________