Hi,
I have a TableA with coloumn "ID" and "Name".
The "ID" have a validation rule "Between 1 AND 10".
Currently I have ID "1,3,4,8" in the database.
I would like to search which ID number that missing.
The result should be ID "2,5,6,7,9,10".
Does anyone have any idea how to query this...