Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> No found data, in select

No found data, in select

From: daniellopez21 <daniellopez21_at_gmail.com>
Date: 5 Jul 2005 04:23:23 -0700
Message-ID: <1120562602.787951.216280@g47g2000cwa.googlegroups.com>


I have the next select:

SELECT

     cu.IMP_FRA_MES
     cump.COD_CUENTA_CABLE,
     clmp.COD_ABONADO_CABLE,
     pamp.COD_PAGADOR_CABLE,
     cump2.COD_CUENTA_CABLE,
     cump3.COD_CUENTA_CABLE

FROM SGI_AC_CUENTAS cu,
     SGI_AC_CUENTAS_MP cump,
     SGI_AC_CUENTAS_MP cump2,
     SGI_AC_CUENTAS_MP cump3,
     SGI_AC_CLIENTES_MP clmp,
     SGI_AC_PAGADORES_MP pamp

WHERE   clmp.cod_abonado = cu.cod_abonado
	and cump.cod_cuenta = cu.cod_cuenta
	and cump.cod_cuenta(+)= cu.cod_cuenta_padre
	and cump.cod_cuenta(+)= cu.cod_cuenta_paga
	and pamp.cod_pagador(+)= cu.cod_pagador

¿the logical of statment is good? :-( I Calling three times, to the SGI_AC_CUENTAS_MP Received on Tue Jul 05 2005 - 06:23:23 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US