Hi all,

I need to move data from 1 table to another table. As there fields' name is different and so I cann't just use 'APPRND FROM TABLEA' to do this. I try to use INSERT BUT VFP6.0 do not support subquery like 'INSERT INTO TABLEB(CO_NAMEB, CO_ADDB) (SELE CO_NAMEA, CO_ADDA FROM TABLEA)' there is syntax error when i run the query. As the field name and table stru is different, it seems difficult for me. I know I can use program and process it record by record but I don't wish to do it as it need some time as I have a large number of records in table. I wish I can just use one statmenet to move data.
TABLEA:
CO_NAMEA, CO_ADDA, CO_MANAGER, CO_REF

TABLEB:
CO_NAMEB, CO_ADDB, CO_REMARK

thanks.
Linda