You cannot create a view which is self-referenced.

The view definitionÆs FROM clause includes the name of this view. Remove the view name from the FROM clause.