I'm trying to display a list of payment Id's from my table that do not exist between a range.
I have this query which shows me what payments exist in a range
select PaymentID from payments where paymentID >000001 and PaymentId < 100000
but I want to display the delta.
ie. The data that does not exist between that range.
Lets say for arguments sake I have 5 records in there
I want to display the 99995 records that dont exist.
How can one do this?