• When outer join is not specified, a logical operation is performed based on the search conditions specified in the SQL, and the system retrieves only those rows for which the result of the evaluation of the search condition is TRUE. When outer join is specified, the rows in the outer table for which the result of the evaluation of the search condition is FALSE are also retrieved.
• A search condition can be specified in any of the following locations:
  
  • ON search condition in the FROM clause
  • WHERE clause
  • HAVING clause
  • WHEN in a search CASE expression
  • WHEN in a trigger action condition
  • IF clause
  • WHILE clause

Format

search-condition::={[NOT] {(search-condition)|predicate}
   |search-condition OR{(search-condition)|predicate}
   |search-condition AND{(search-condition)|predicate}
predicate::={NULL-predicate|IN-predicate|LIKE-predicate|XLIKE-predicate|SIMILAR-predicate|BETWEEN-predicate|comparison-predicate|quantified-predicate|EXISTS-predicate|logical-predicate|structured-repetition-predicate}