>I may be wrong, and if you say so, I probably am. It's funny how fast you forget how old some features are. I guess I mixed this up with the new SQL Update options.
>

Tore, this is normal for the human mind.

In fact, a few years on the past someone it has invented the writing.

The tragic-funny thing is this:
- after many version, the VFP9 help have not a "this is supported in vfpX,Y,Z".

The MS moves billion of dollars,
it has thousand of employees,
but after 30 years it has not understood as a manual should to be written.

>>>VFP9: yes, VFP8: no.
>>>
>>
>>Tore, are you sure ?
>>
>>>>In VFP9 (8?) you can do
>>>>
>>
>>this sintax is wrong
>>
>>>>insert into myTable from (select myfields from myOthertables where myFilterCondition).
>>
>>

>>insert into myTable (myfiels) 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