>Can anyone explain why the following command would display the "Overwrite?" dialog twice if table StockBySize3 already exists? (SET("SAFETY") = "ON"). The end-result is still correct.
>
>

>select * from StockBySize;
>	union select * from StockBySize2;
>	into table StockBySize3
>

>
>(Using VFP 6, SP5)

Adding another union gives 3 "Overwrite" dialog's. I'm guessing that each select writes to the table as it is performed, rather than creating a temporary table then copying to the final table.