Re: Rows/no rows

From: Thomas Olszewicki <ThomasO_at_cpas.com>
Date: Thu, 23 Aug 2007 12:48:43 -0700
Message-ID: <1187898523.094110.55090@l22g2000prc.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(+)
Try
select PR_EQUIV.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(+) Thomas Received on Thu Aug 23 2007 - 14:48:43 CDT