Re: Need to clip x,y points that fall inside a polygon

[Carl Longnecker]

so you have a table of points and table of polygons? and you want to compare them? that's a join:

select point.name
     , region.name
  from point
  join region
    on contains(region.gisdata, point.gisdata)

this will return all points that exist in any of the polygons in the region table.