>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
If the Tamar's suggestion somehow didn't match your need you could try:
SELECT * from Table1 WHERE Field1 = 1 INTO CURSOR crsTest
SELECT Table2
APPEND FROM (DBF([crsTest]))
Against Stupidity the Gods themselves Contend in Vain - Johann Christoph Friedrich von Schiller
The only thing normal about database guys is their tables.