Try something like this SELECT DISTINCT boundary.* FROM boundary, location WHERE ST_Intersects (boundary.geom, location.geom)