Is it possible in VFP6 to use the SQL INSERT command to add records from one or more tables?
For the example the following works with standard SQL:
Insert into table1 select * from table2 where x = y

Thanks
Niall