Opps, seems it should be

APPEND FROM (dbf('crsTemp'))

- as an expression.

>Hi Vlad,
>
>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?
>
>>>Hi!
>
>>>You cannot do this within a single statement.
>
>>>"APPEND FROM" could not be part of the SELECT - SQL statement.
>
>>>So, in your case this will look probably as following 3 commands:
>
>
>>>Select tableA.field5 as fieldtotal ;
> FROM tableA INNER JOIN tableB ;
> ON tableA.namefield = tableB.namefield ;
> WHERE tableA.datefield = tableB.datefield ;
> into cursor crsTemp
>SELECT MyTableForAppending
>APPEND FROM dbf('crsTemp')