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 -> Re: no return rows

Re: no return rows

From: tina london <tinalondon_at_demon.co.uk>
Date: Wed, 6 Jul 2005 14:42:57 +0100
Message-ID: <dagn4l$cr1$1$830fa17d@news.demon.co.uk>

"daniellopez21" <daniellopez21_at_gmail.com> wrote in message news:1120650361.646800.201380_at_g14g2000cwa.googlegroups.com... 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?

why not !! Received on Wed Jul 06 2005 - 08:42:57 CDT

Original text of this message

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