There's many possible translations in the underlying base tables and again the SQL standard disallows subqueries referencing the same table as the outer query because of the ambiguity of modifications on this type of view. 