Hi Sergey,
I am now getting an "Operator/Operand type mismatch" How do I determine which fields are causing this error? The fields are of the same name, type and width so could it be something else?

>>Here's corrected code

>>Select tableA.field5 as fieldtotal ;
FROM tableA ;
INNER JOIN tableB ON tableA.namefield = tableB.namefield ;
AND tableA.datefield = tableB.datefield
INTO cursor crsTemp

SELECT mytable
append from ( dbf('crsTemp') )