Re: no return rows

You must have some rows in a and c that share a cod_abonado, and at the same time those a rows must share a cod_cuenta value with b. "d" rows don't matter, since it's an outer join.

So, look in a for specific row occurences you feel should be showing up, and go look at b and c and make sure there exist rows there that satisfy *both* of the join conditions.

Without seeing your data, it's hard to say more than that.

Tom Best

daniellopez21 wrote:
> Why the select, no return rows??
>
> SELECT a.myfield
>
> FROM table1 a,
> table2 b,
> table3 c,
> table4 d
>
> WHERE c.cod_abonado = a.cod_abonado
> and b.cod_cuenta = a.cod_cuenta
> and d.cod_cuenta(+)= a.cod_cuenta_padre
> and b.cod_cuenta(+)= a.cod_cuenta_paga;
> and b.cod_pagador(+)= a.cod_pagador
>
> ¿for the joins?
>
Received on Wed Jul 06 2005 - 08:01:07 CDT