>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
You can use INSERT-SQL instead, e.g.
insert into Table2 select * from Table1 where field1 = 1
If it's not broken, fix it until it is.
My Blog