Subject Re: [firebird-support] Firebird get the list with all available id
Author Virna Constantin
maybe help you:

In a table I have records with id's 2,4,5,8. How can I receive a list with values 1,3,6,7. I have tried in this way
>FROM table t1
>    SELECT *
>    FROM table t2
>    WHERE = + 1
>but it's not working correctly. It doesn't bring all available positions.
>Is it possible without creating another table?

[Non-text portions of this message have been removed]