>>It is possible to use append from command in the current table with conditions of another table?..
>>
>>Like this:
>>
>>
>>Select table1
>>
>>Select table2
>>Append from table1 for table1.field1 = 1
>>
>>
>>
>>Trying to use this command, but it transfers all the records of table1…
>>Any better idea?..
>>
>>Thanks in advance
>>Carlos Burgos
>
>
>Insert into table2 select * from table1 where table1.field = 1
>
It helps sometimes to read the whole thread before replying <g> Though I quite often can not keep the urge to answer without finishing reading the whole thread :)
If it's not broken, fix it until it is.
My Blog