Problem by query with subquery

From: Andrei Romazanov <ierdna_at_web.de>
Date: Tue, 27 May 2003 13:22:50 +0200
Message-ID: <bavhq3$42bba$1@ID-70985.news.dfncis.de>

Hello all,

i have a query 1 with subquery:

SELECT A.F2,B.F2,C.F3 FROM A,B,(SELECT F3 FROM TAB) C the query 2 (without subquery ) SELECT A.F2,B.F2 FROM A,B selects some rows, the query 3 (subquery ) SELECT F3 FROM TAB - no rows.

I thought that the query 1 selects the same rows as query 2, but it selects no rows!!!
If I manipulate the data so that query 3 selects some rows , than selects query 1 also some rows. I often work with subqueries, but I did not see this behavior yet. Could someone explain this problem?

ORACLE 8.1.7, Windows 2000

Thanks in advance
Andrei Received on Tue May 27 2003 - 06:22:50 CDT