--- In firebird-support@yahoogroups.com, Alan.Davies@... wrote:

>
> Wouldn't it be a whole lot easier if you had a Select_Yes/No field in
> your main table. How does your user decide which CUSTOMERS he/she
> wants? By a tick-box in a grid or similar.
> This way you could use:
> SELECT * FROM CUSTOMERS WHERE Select_Yes/No='Y'
>
> No limits; faster as well. No compromise on your security model either.

Yes. Much easier ...... until you want to have more than one user.

Joining to temporary tables are the easiest way to implement this in a
multi-user safe way. (You can use real tables providing you remember
to empty them yourself if you aren't on 2.1).

Adam