>Hi.
>I have two questions about SQL Insert command when
>used with SELECT:
>
>1. The fields name must be specified one by one in the Insert
>clause of the command and again in the SELECT clause?

In general, it's not required but is necessary if there's mismatch between fields in source and destination.

>2. The name of the table could be an alias or must be the dbf name?

Either can be used