ALL

When you specify the ALL keyword before a subquery, Pervasive PSQL performs the subquery and uses the result to evaluate the condition in the outer query. If all the rows the subquery returns meet the outer query's condition for a particular row, Pervasive PSQL includes that row in the final result table of the statement.

Generally, you can use the EXISTS or NOT EXISTS keyword instead of the ALL keyword.

Examples

The following SELECT statement compares the ID column from the Person table to the ID columns in the result table of the subquery:

SELECT p.ID, p.Last_Name

FROM Person p

WHERE p.ID <> ALL

(SELECT f.ID FROM Faculty f WHERE f.Dept_Name = 'Chemistry')

If the ID value from Person does not equal any of the ID values in the subquery result table, Pervasive PSQL includes the row from Person in the final result table of the statement.