>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?
1. If the names of the fields in the other table match the names of the fields and the order in the other table you can use
insert into myTable select * from myOtherTable where ...
otherwise
insert into myTable (field1, field2, field3) select field1, field2, field3 from ...
>2. The name of the table could be an alias or must be the dbf name?
>
>Thanks in advance!
Yes, it could be the name of the cursor (not the real table name). You can also use table alias.
If it's not broken, fix it until it is.
My Blog