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:
Which I've tried with and without the single quotes. And in addition to which, I tried:Code:AND (id <> '4151')
Also, I've tried:Code:AND (id != '4151')
And that didn't work either.Code:AND (id NOT IN (4151))
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.