Here, the `WHERE` clause contains a `single_valued_path_expression`. The `p` is an identification variable, and `salary` is a persistent field of `Player`.

SELECT DISTINCT p FROM Player p WHERE p.salary BETWEEN :lowerSalary AND :higherSalary

Here, the `WHERE` clause also contains a `single_valued_path_expression`. The `t` is an identification variable, `league` is a single-valued relationship field, and `sport` is
a persistent field of `league`.

SELECT DISTINCT p FROM Player p, IN (p.teams) t WHERE t.league.sport = :sport

Here, the `WHERE` clause contains a `collection_valued_path_expression`. The `p` is an identification variable, and `teams` designates a collection-valued relationship field.

SELECT DISTINCT p FROM Player p WHERE p.teams IS EMPTY

- © 2010, Oracle Corporation and/or its affiliates