Add INSERT to the previous list. Yes, INSERT INTO SELECT FROM is new for VFP8. It's all documented in VFP8 help under What's New in Visual FoxPro 8.0.

>Hi Sergey,
>
>There does seem to be some differences though.
>Here's code that doesn't work in VFP6 but evidently does work in VFP8.
>
>>INSERT INTO employee (EmpNo, LastName, FirstName,
>> PhoneExt, HireDate, Salary)
>> SELECT EmpNo + 200, LastName, FirstName,'000',
>> HireDate, Salary + 1000
>> FROM empins