AnsweredAssumed Answered

Database view - Help with Statement

Question asked by pan_gis on Oct 2, 2019
Latest reply on Oct 3, 2019 by pan_gis

Hi!

 

Very basic question. not for me....

 

I am trying to create a database view with this statement. (both from catalog and from toolbox)

 

CREATE VIEW readings_view
 AS SELECT (b.shortname,b.longname,r.timestamp,r.room,r.acmode,r.actemp)
 FROM #nameofFeatureClass# b, #nameOfTable# r
 WHERE b.shortname = r.room;

 

I get this error

 

There is already a relationship 1:M between the two. but I am trying to crate this view and publish it as I need to crate a symbology from related table. I read that creating a database view is a possible way but I cannot get it.

 

What do I do wrong?

 

I am trying to replicate what is in here: Example: Create database views in SQL Server using SQL—Help | ArcGIS Desktop

 

thanks!!! 

Outcomes