Nigel,

>Can you give some examples of the alias names and table names. BTW, you are >referring to tables as databases!?!

>What is the name of the table and alias you are selecting?
>What is the name of the table being selected?
>Is the table being selected the one already in the current work area when you try to select?

- We are using free tables rather than a DBC ... you are correct we should be talking about tables.

- The name is "SIFALL" and the alias is "SIFALL".
- "SIFALL" is being selected.
- The table name being selected "SIFALL".
Yes it should be in the current work and we expect it to be .... but its not.

Richard