I am trying to find a way in SQL to get a list of all values that do not
exist in a field. As in...
where "value" not in (select "number" from file)
It's more complex than that, but if I can get the basics then I should
be able to expand it.
Let's say I have a file that has a field "number". It's a 3-digit
field. I know that over 800 of the 999 possible (non-zero) values are
already used. I need to know which values are not used.
I've tried using CREATE SEQUENCE and it creates a Data Area (with junk
I suppose I could create a file of nothing but sequential numbers from 1
to whatever, but I'm hard-headed and this really shouldn't be that hard.
As an Amazon Associate we earn from qualifying purchases.
Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.