I'm using ArcMap to join some datasets and one of the datasets is a materialized view. When I do an attribute join it qualifies the name of each table involved so they look like <schema_name>.<table_name>. This is all good if you do a join on two tables but if you join to a view or materialize view the table name looks like <schema_name>.%<table_name>.
Basically it is putting a percentage sign in the table name for some reason. This prevents ANY queries from being done against the table because percentage signs are invalid in table names.
Why is ArcMap changing the table name?
I'm using ArcMap 10.2.2