I have a select Query that, when a user search for a range of numbers lets say :
FROM ID 1 to ID 15
right now in my query, if ID 9 and 10 does not exist at all, in my result I will show only the IDs are obviously exists like this
what I would like, is that, I would like to show 9 and 10 with a note "DELETED" so that the user knows why its not there anymore.
my query starts with SELECT * from myMainIDTable m and some other inner join / left join for other informaiton
and in my WHERE clause I do WHERE m.ID >= txtFrom.Value and m.ID <= txtTO.Value
so if the ID is not in M, it will not show, but I would like to show with a note.
how can I do that ?