Jim,
You hit it, good catch. I didn't notice that the alias started with a number on line 2. That means that the alias was not used and the table name was used as the alias.
>>Hi Mike!
>>
>>If that is true then why is it that the following works:
>>
>>line1: close all
>>line2: use table1 in 0 alias table1alias
>>line3: use table1 again in 0 alias table1
>>
>>Thanks
>>Dave Mihalik
>>
dmihalik@stansleygroup.com