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.
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?