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 have created a view by joining a feature layer and 2-3 other tables in ArcSDE database using help from James Richard Post. The view gets created fine in both SQL Server 2008 and also in SDE. In SQL Server it shows records and geometry but when it comes to ArcGIS it does not show table or geometry in ArcGIS Desktop 10.1.
enter image description here.
It shows only the geometry in ArcCatalog but not the table in preview table.

Below is my code:

SELECT SPE.[OBJECTID] ,SPE.[BaseId], SPE.[PlayId] , B.[BasinName], SP.[ShaleName], AGS.[AgeS],  SP.[Ref] , SPE.[Shape] , SPE.[Shape_STArea__], SPE.[Shape_STLength__]
    FROM [dbo].[Play] SPE inner join [dbo].[Base] B on SPE.[BaseId]=B.[OBJECTID]
        inner join [dbo].[shale] SP on SPE.[Shale]=SP.[OBJECTID]
        inner join [dbo].[Age] AGS on SPE.[AgeId]=AGS.[OBJECTID]
share|improve this question
add comment

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.