At 4:54 +0200 9/10/02, Jan Broermann wrote:
>I'm missing an answer to a topic which came up a couple of days /weeks ago.
>For a database i'm administrating I would like to find out, which numbers
>are missing in our database. Is there a way to get this result set thru SQL?
>Or do I have to do it with for example Java?
>I think somebody else asked a question similar to my probleme, but I can't
>an answer in my mails. I think it must be a construction of something like
>not in between [max]max(tab.invoice) and [min] min (tab,invoice) ????????
You need a reference table that lists all the invoice IDs in the range
that you want to check. Then you can perform a left join of this table
against your invoice table to find non-matching records.
If you have no such reference, then you can select the IDs that do happen
to lie within the range, and apply some programming logic to figure out
which ones aren't there.
>thx from Germany