Publish Feature Layer with 2 sql server tables join

[abhishek_choudhary]

Hi,

I attempted to create a feature layer by joining two tables, one containing spatial data, and the other with additional attributes. However, I encountered an issue when trying to publish it. The error message indicated that the join operation was being performed in local memory, preventing successful publication. 

I want to utilitize this feature layer with the geoevent server where the feature data will be updated in real time.So does the changes should be reflected in the sql database.

Can someone please suggest a better approach how can we publish the  feature layer .

[Ed_]

That's because the join is temporary.

Right click on the spatial data that contains the join data and then click on data and then click on Export and create a new feature class (spatial data). Now publish the newly created spatial data which now has the joined data permanently. 

[VinceAngelo]

The other option is to use a true JOIN clause in a VIEW, but doing so is tricky, since you need to preserve a unique rowid column.

- V