>I see that my "FROM" was causing the problem. Thank you very much for your help.
>
>If I may ask you on the same topic. In most cases the SCATTER and GATHER will be used against tables of the same structure. But what is the structure slightly different. Will it cause an error on GATHER?

It shouldn't unless a field with the same name would have different type in the object and in the cursor and VFP couldn't convert between those types.