Thanks!
>>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.
***
TONY Nascimento
*****************
"Your mind is like a parachute. It only works if it is open" - Anthony J. D'Angelo
"The desire to know is natural to good men" - Leonardo da Vinci