AnsweredAssumed Answered

sql syntax arcSDE query layer points within polygon

Question asked by timdunlevie on Apr 14, 2016
Latest reply on Apr 17, 2016 by timdunlevie

Hi all,

 

We have a Microsoft sql server which our ArcSDE is located on.

In the database are a collection of feature classes.

I want to add a query layer using 2 feature classes.

It's a simple query involving a points FC & a polygon FC.

I want to query points which are within a polygon based on an attribute.

for example:

select * from FC_Points, FC_Polygon

where FC_Points are within FC_Polygon and FC_Points.ID = FC_Polygon.ID

could someone point me in the right direction to write the syntax?

Many thanks

Outcomes