>It appears as if the table created with CREATE filename2 FROM filename1 not only assumes the current alias but CLOSES the previous alias...My apologies if this has already been addressed
>
>-Q
Opening a new table with USE would close the previous alias; and I assume that creating a table in the current alias would do the same.
If this is not what you want, perhaps a SELECT 0 before the CREATE will help.
Difference in opinions hath cost many millions of lives: for instance, whether flesh be bread, or bread be flesh; whether whistling be a vice or a virtue; whether it be better to kiss a post, or throw it into the fire... (from Gulliver's Travels)