Rows/no rows

From: astalavista <nobody_at_nowhere.com>
Date: Thu, 23 Aug 2007 21:30:42 +0200
Message-ID: <46cde05e$0$420$426a74cc@news.free.fr>

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(+)   Received on Thu Aug 23 2007 - 14:30:42 CDT