SQL, Trying to get opposite result

97 views Asked by At

So, I was trying to select data but all I can get is opposite of results that I need.

SELECT DISTINCT
  LAND_USE_EVW.OBJECTID
FROM LAND_USE_EVW,
     MUNICIPALITIES_EVW
WHERE LAND_USE_EVW.Shape.STBoundary().STWithin(MUNICIPALITIES_EVW.Shape) = 1

When I change 1 to 0 it's not working (selecting all rows)

What could I possibly do to get opposite result?

0

There are 0 answers