Re: No found data, in select

daniellopez21 wrote:
> 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
Logical only if the point is to create a Cartesian Join.

The WHERE clause does not join anything to cump2 or cump3.

-- 
Daniel A. Morgan
http://www.psoug.org
damorgan_at_x.washington.edu
(replace x with u to respond)