I'm trying to build a query that excludes specific rows by their ID, but I can't get it to work. Right now, I have:
AND (id <> '4151')
Which I've tried with and without the single quotes. And in addition to which, I tried:
AND (id != '4151')
Also, I've tried:
AND (id NOT IN (4151))
And that didn't work either.
Eventually, I'll need to be able to exclude several rows at a time.
Yes, the core query works just fine.
Yes, the ID column exists.
Yes, the record also exists.