Re: Rows/no rows

From: Ed Prochak <edprochak_at_gmail.com>
Date: Thu, 23 Aug 2007 20:54:40 -0000
Message-ID: <1187902480.507818.116690@q3g2000prf.googlegroups.com>

On Aug 23, 3:30 pm, "astalavista" <nob..._at_nowhere.com> wrote:
> Hi,
>
> Something weird happened, the first query retruns rows but not the second
> Have you an explanation ? ( 9.2.0.6 AIX)
>
> Thanks in advance
>
> select * from
> V_PROD_INT S_PROD_INT,
> S_PROD_INT PR_EQUIV,
> S_ORG_EXT
> WHERE
> S_PROD_INT.PR_EQUIV_PROD_ID = PR_EQUIV.ROW_ID(+) AND
> S_PROD_INT.VENDR_OU_ID = S_ORG_EXT.ROW_ID(+)
>
> select S_PROD_INT.row_id from
> V_PROD_INT S_PROD_INT,
> S_PROD_INT PR_EQUIV,
> S_ORG_EXT
> WHERE
> S_PROD_INT.PR_EQUIV_PROD_ID = PR_EQUIV.ROW_ID(+) AND
> S_PROD_INT.VENDR_OU_ID = S_ORG_EXT.ROW_ID(+)
That seems puzzling. have you tried this? What happens?

select S_PROD_INT.<primary key>
from

     V_PROD_INT S_PROD_INT,
     S_PROD_INT PR_EQUIV,
     S_ORG_EXT

WHERE
    S_PROD_INT.PR_EQUIV_PROD_ID = PR_EQUIV.ROW_ID(+) AND     S_PROD_INT.VENDR_OU_ID = S_ORG_EXT.ROW_ID(+)   ed Received on Thu Aug 23 2007 - 15:54:40 CDT