Ah, sorry, I missed one point. The field name of the 2 tables are not the same.
I want:
insert into tableB (username, email) select loginname as username, loginemail as email from tableA

That is why I can't just use append.
Thanks.

>>I want to append all the data from table A to table B.
>>I thought I can use SQL like:
>>insert into tableB (username, email) select username, email from tableA
>>but the help file shows me that "insert into ...select" statement seems not work in VFP. Right? What should I do?
>
>

>use TableB
>append from TableA
>