In VFP9 (8?) you can do
insert into myTable from (select myfields from myOthertables where myFilterCondition).
Check the INSERT-SQL command in Help.
>hi all,
>
>any idea , help
>i try to append new records to mytable, as under
>
>
>Select * from rami3 ;
> where inList( upper(allt(sec_txt)), "ÞØÇÚ ÇäÙãÉ ÇáãÚáæãÇÊ ") ;
> append blank;
> into table rami4 nofilter
>
>thanks
If it's not broken, fix it until it is.
My Blog 
