While multiple row insertion is allowed in SQL-server; this is not so in VFP (sigh).
In SQL Server: This works!
CREATE TABLE #test (fld1 nvarchar(10))
INSERT #test SELECT fld1 FROM test2 where fld1 = 'TEST'

This will insert all records FROM test2 INTO test meeting the criteria.

>you need to SCAN the table or, if they are not too big and they are same structure
>you can do:
>

>SELECT alias1
>copy to array aAlias1
>SELECT alias2
>APPEND FROM ARRAY aAlias1
>

>
>>hey everyone,
>>here is the problem. it is like the previous one i have posted but with a new twist. the first problem was a different angle on trying to solve this one. here is the scenario:
>>
>>i have to table i have set up as alias.
>>alias1 and alias2
>>
>>i then preceed to excecute the following code:
>>select alias1
>>insert into alias1 ;
>> fields ;
>>values alias2->fields
>>
>>the problem is that i only insert one record into alias1 from alias2 when i want to insert all alias2 records. what am i doing wrong?? any suggestions would be appreciated. thanks.