Hi
No. VFP 6.0 does not support something like INSERT INTO MyAlias (SELECT * FROM OtherAlias). Though if you break these sqls into 2 statements you can achieve the results by...
SELECT * FROM OtherAlias INTO ARRAY MyArray
INSERT INTO MyAlias FROM ARRAY MyArray
>For those who have the VFP6 beta, is there support for SQL's multi-row insert?. TIA