The IS EMPTY Expression

SELECT p
FROM Player p
WHERE p.teams IS EMPTY

• Data retrieved: All players who do not belong to a team.

• Description: The teams relationship field of the Player entity is a collection. If a player does not belong to a team, the teams collection is empty, and the conditional expression is TRUE.

• See also: Empty Collection Comparison Expressions.