This content has been marked as final. Show 2 replies
In your WHERE clause you test many different table columns, then we don't know what they contain, so that we cannot tell you what is wrong. Try to test you SQL order with Sql*Plus or Toad to see if the correct rows are fetched.
see that you wrote
condA or condB and condC without ()
are you sure that you want this?