It's possible in VFP8. In VFP6 you will do it in two steps.

select * ;
  from table2 ;
  where x = y ;
  INTO CURSOER crsTemp NOFILTER

SELECT table1 
APPEND FROM ( DBF("crsTemp") )
USE IN crsTemp

>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