| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
Home -> Community -> Usenet -> c.d.o.server -> No found data, in select
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
![]() |
![]() |