Progress
SQL-92
Guide and Reference


Basic Predicate

A basic predicate compares two values using a relational operator. See the "Relational Operators" section for information about relational operators. If a basic predicate specifies a query expression, then the query expression must return a single value. Basic predicates often specify an inner join. See the "Inner Joins" section for more information.

If the value of any expression is null or the query_expression does not return any value, then the result of the predicate is set to false.

This is the syntax for a basic_predicate:

SYNTAX
expression relop { expression | ( query_expression ) } 


Copyright © 2004 Progress Software Corporation
www.progress.com
Voice: (781) 280-4000
Fax: (781) 280-4095