While using "Make Query Table" tool on an ArcSDE feature class(versioned) and an attribute view, the functions fails to execute saying "Attribute column not found". The multi-part identifier SDE featureclass.columnname could not be bound.
What I am trying to do is a join between the feature class and table on A.x = B.y
A= SDE feature class
B = attribute view
x & y are text fields, 20 character long. The error says column x in feature class A cannot be found.
If I try the same join from SQL server backend on the same feature class and view it works perfectly.
Any idea what is happening on the arc client?
Thanks in advance,
In this case I could not join a SQL Server view to a Featureclass in the Map Document.
I had to delete the SQL View from within ArcCatalog rather than a drop and create from within SSMS.