Creating Query table from sql view

62
0
4 weeks ago
Labels (3)
AdCulver
New Contributor II

I am trying to create a query table from a sql view; there is no geometry associated with the table. I need to join the table to two separate feature classes. When I try to run the "Make Query Table" tool I get the following error: 000055: Cannot create a Query Table for this workspace: Description Creating a query table is not supported for the specified workspace. Query tables can only be created using data from a geodatabase or an OLE DB connection. Solution Convert the data to one of the workspace types that support the creation of query tables. I am directly connecting to the sql database through my project. I do not want to convert the view into a static table so the data is "live" and attributes will update without having to refresh or run a script. Any ideas are greatly appreciated.

Capture.PNG

0 Kudos
0 Replies