recursive query extracts 0 rows
Hello everybody,
I am trying to run the following query:
"select ID from table
where ID NOT IN (select ID from second_table where account = 1);"
The query extracts 0 rows although there are many rows in the first table that are not extracted by the inner query.
Did I use the syntax and logic correctly?
Subject
Views
Written By
Posted
recursive query extracts 0 rows
6562
May 18, 2005 08:25AM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.