Take the 2-minute tour ×
Geographic Information Systems Stack Exchange is a question and answer site for cartographers, geographers and GIS professionals. It's 100% free, no registration required.

I need to join a feature layer with a SQL Server View with a common field in ArcMap. The View was successfully added to ArcMap as data table with some query built on it from Query Builder.

When I tried to make join on those two layers it returned nothing in the attribute table.

However, if I modified the view definition with exactly the same query in SQL Server, the View added to ArcMap and joined with the feature layer returned records in the attribute table.

I would like to enable the user to build their query on the added View as table in ArcMap rather than currently having to do it in View definition on the SQL Server side.

Just wonder if anybody came across the problem before. Is there any workaround for it?

Thanks

Alex

share|improve this question
add comment

Know someone who can answer? Share a link to this question via email, Google+, Twitter, or Facebook.

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Browse other questions tagged or ask your own question.