TechQA.

SQL, Trying to get opposite result

89 views Asked by Minnu P At 27 November 2024 at 05:47

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?

There are 0 answers