Power,
Do it in two steps:

SELECT loginname AS username,;
       loginemail AS email;
 FROM tableA;
INTO CURSOR TempA

SELECT TableB
APPEND FROM (DBF("TempA"))

>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
>>