You specified an unqualified set relation within the WHERE clause of a nested SELECT.
Reason:
Set relationships between two tables can be specified in the WHERE clause of a nested SELECT only if one of the tables is in the FROM list at that nest level.