I am trying an create the indexed view after joining two non related tables. Please correct me if my approach is wrong and add your thoughts for the issue I had mentioned below.
Syntax used for creating view
CREATE VIEW MyViewName
select field1, field 2 from tableOne (not the exact query)
FULL OUTER JOIN
select field1, field2 from tableTwo (not the exact query)
Syntax used for creating index on view
CREATE UNIQUE CLUSTERED INDEX ClusteredIndexTest
Issue occurred while trying to create index
Cannot create index on view "db.dbo.MyViewName" because it references derived table "tableOne" (defined by SELECT statement in FROM clause). Consider removing the reference to the derived table or not indexing the view.