>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
--sb--